The clean_workbook functions exports a list or a dataframe/tibble to nice xlsx file using openxlsx.
clean_workbook_list()takes a named_list as main arg and writes a xlsx file where each list item is a tab.clean_workbook_df()takes a dataframe as main arg and writes a single-tabbed xlsx file.
Usage
clean_workbook_list(
named_list,
path,
col_width = 15,
max_width = 60,
font_name = "Leelawadee",
font_size = 10,
table_style = "TablestyleMedium10"
)
clean_workbook_df(
df,
name,
path,
col_width = 15,
max_width = 60,
font_name = "Leelawadee",
font_size = 10,
table_style = "TablestyleMedium10"
)Arguments
- named_list
A named list of tibbles/dataframes.
- path
A full full or relative path that includes file name.
- col_width
Minimum column width. Default to 15.
- max_width
Maximum column width. Default to 60.
- font_name
Font name. Default to "Leelawadee".
- font_size
Font size. Default to 10.
- table_style
Excel table style. Default to "TablestyleMedium10".
- df
Dataframe to export
- name
Character string if the spreadsheet name