Package: openxlsx2Extras 0.0.0.9000

openxlsx2Extras: Extra Functions for the openxlsx2 package

Extends the openxlsx2 package with wrapper and helper functions designed to add new features and options when working with Excel workbooks.

Authors:Eli Pousson [aut, cre, cph], Jan Marvin Garbuszus [ctb]

# Install 'openxlsx2Extras' in R:

install.packages('openxlsx2Extras', repos = c('https://elipousson.r-universe.dev', 'https://cloud.r-project.org'))

On CRAN:

Last updated 28 days agofrom:7c7a8bf8f0. Checks:1 OK, 7 NOTE. Indexed: yes.

Help page	Topics
Prepare a character vector as a data validation string	as_data_validation_value
Coerce a data frame or list of data frames to a workbook	as_wb
Common dxfs styles	common_dxfs_styles
Convert CSV to XLSX files or XLSX to CSV	convert_to csv_to_wb csv_to_xlsx xlsx_to_csv
Format logical vector columns to use replacement values	fmt_lgl_cols
Use 'marquee::marquee_parse()' to format Markdown text	fmt_marquee_txt
Prepare data for adding to a workbook	prep_wb_data
Create a data frame from a Workbook (with extra features)	read_xlsx_ext
Prepare a data frame with Excel style class values for formatting by openxlsx2	set_excel_fmt_class
Format a logical vector to specified values	vec_fmt_lgl
Add data using 'openxlsx2::wb_add_data()' with extra features	wb_add_data_ext
Add Markdown formatted text to a Workbook	wb_add_marquee_text
Add a named list of styles to a workbook	wb_add_styles
Create a new workbook and add named work sheets	wb_new_workbook
Save a workboook object to file while filling file name from assigned workbook title	wb_save_ext
Set workbook properties	wb_set_properties_ext
Use 'dplyr::group_split' to split a workbook into a list of workbooks	wb_split
Convert a workbook to a list of data frames	wb_to_df_list
Write data to an xlsx file with additional features	write_xlsx_ext