Last chance! 50% off unlimited learning
Sale ends in
Turns cell formatting into annotations for values in the target variable.
annotate_mf(xlfilepath, orig, new)A tibble with a new column in which the meaningful formatting is embedded as text.
Path to a single-sheet spreadsheet file (xls or xlsx).
Target variable to annotate formatting in.
Name of new variable with cell formatting pasted as a string.
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; this includes blank but formatted cells beyond the data rectangle.
example_spreadsheet <- system.file("extdata/dog_test.xlsx", package = "unheadr")
annotate_mf(example_spreadsheet, orig = Task, new = Task_annotated)
Run the code above in your browser using DataLab