Package index

All functions

as_data_validation_value()

Prepare a character vector as a data validation string

as_wb()

Coerce a data frame or list of data frames to a workbook

common_dxfs_styles

Common dxfs styles

csv_to_wb() csv_to_xlsx() xlsx_to_csv()

Convert CSV to XLSX files or XLSX to CSV

fmt_lgl_cols()

Format logical vector columns to use replacement values

fmt_marquee_txt() experimental

Use marquee::marquee_parse() to format Markdown text

prep_wb_data()

Prepare data for adding to a workbook

read_xlsx_ext() experimental

Create a data frame from a Workbook (with extra features)

set_excel_fmt_class() experimental

Prepare a data frame with Excel style class values for formatting by openxlsx2

vec_fmt_lgl()

Format a logical vector to specified values

wb_add_data_ext() experimental

Add data using openxlsx2::wb_add_data() with extra features

wb_add_marquee_text() experimental

Add Markdown formatted text to a Workbook

wb_add_styles()

Add a named list of styles to a workbook

wb_new_workbook()

Create a new workbook and add named work sheets

wb_protect_worksheets()

Protect one or more sheets in a workbook

wb_rename_data()

Rename column names in workbook data

wb_rename_sheets() wb_rename_sheets_with()

Rename workbook sheets using a tidyselect syntax

wb_save_ext() experimental

Save a workboook object to file while filling file name from assigned workbook title

wb_set_properties_ext()

Set workbook properties

wb_split()

Use dplyr::group_split to split a workbook into a list of workbooks

wb_to_df_list()

Convert a workbook to a list of data frames

write_xlsx_ext() experimental

Write data to an xlsx file with additional features