Turns cell formatting into annotations for all values across all variables.
annotate_mf_all(xlfilepath)
xlfilepath | Path to a single-sheet spreadsheet file (xls or xlsx). |
---|
A tibble with meaningful formatting embedded as text for all rows and columns.
At this point, seven popular approaches for meaningful
formatting (bold, colored text, italic, strikethrough, underline, double underline, and cell highlighting) are hardcoded in
the function. sheets
, skip
, and range
arguments for spreadsheet input
are not supported. The hex8 code of the fill color used for text color and cell
highlighting is also appended in the output. Ensure the data in the
spreadsheet are rectangular before running.
example_spreadsheet <- system.file("extdata/boutiques.xlsx", package = "unheadr") annotate_mf_all(example_spreadsheet)#> # A tibble: 7 x 6 #> `Store Location` Q1_2012 Q1_2013 Q1_2014 Q1_2015 Q1_2016 #> <chr> <chr> <chr> <chr> <chr> <chr> #> 1 (highlight-FFADC5E… (highlight… (bold, hig… (highlight… (highlight… (bold, hi… #> 2 (highlight-FFADC5E… (highlight… (highlight… (highlight… (bold, hig… (highligh… #> 3 (highlight-FFF37B7… (bold, hig… (highlight… (highlight… (highlight… (highligh… #> 4 (highlight-FFADC5E… (highlight… (bold, hig… (bold, hig… (bold, hig… (highligh… #> 5 (highlight-FFADC5E… (highlight… (highlight… (highlight… (highlight… (highligh… #> 6 (highlight-FFF37B7… (bold, hig… (highlight… (bold, hig… (highlight… (bold, hi… #> 7 (highlight-FFADC5E… (highlight… (highlight… (highlight… (highlight… (highligh…