Skip to content

Write into documentation that compatibility with Excel is increased by using mso-number-format #63

@rasmusrhl

Description

@rasmusrhl

If you style each cell with the CSS format "mso-number-format", then compatibility with Excel is increased. I did not know this before this SO-question. So maybe it is a good idea to put in the manual :)

Use this css-matrix
css_matrix <- matrix( data = "mso-number-format:\"\\@\"", nrow = nrow(df), ncol = ncol(df))

SO question:
https://stackoverflow.com/questions/48151491/convert-html-table-to-excel-using-vba

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions