annotate_mf | R Documentation |
Turns cell formatting into annotations for values in the target row.
annotate_mf(xlfilepath, orig, new)
xlfilepath |
Path to a single-sheet spreadsheet file (xls or xlsx). |
orig |
Variable to annotate formatting in. |
new |
Name of new variable with cell formatting pasted as a string. |
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.
A tibble with a new column with meaningful formatting embedded as text.
example_spreadsheet <- system.file("extdata/dog_test.xlsx", package = "unheadr") annotate_mf(example_spreadsheet, orig = Task, new = Task_annotated)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.