Write and style notes

write_notes() writes notes/footnotes provided in df to the appropriate sheet.

Usage

write_notes(df, notes_title = "Notes:", wb, sheet_name, bounds)

Arguments

df

data frame to be written

notes_title

character string with the title (first line) of the notes.

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

bounds

named integer vector identifying integer sheet start and end reference column. All parameters must be numerical. For converting Excel column references to integer references see openxlsx::int2col(). Must have the following named elements:

• start_col: start column

• end_col: end column

• start_row: start row

• end_row: end row