load_save_excel: Load/save excel workbooks using openxlsx library

In mathosi/jj: Just Joise

Load/save excel workbooks using openxlsx library

Description

load excel workbook as list of data.frames or save list of data.frames as excel

Usage

jj_load_excel(file_name, sheet_names = NULL, row_names = FALSE, ...)

jj_save_excel(
  list_of_df,
  file_name,
  sheet_names = NULL,
  row_names = FALSE,
  ...
)

Arguments

file_name	Full path to the file to read or write
sheet_names	Names of sheets to read or write, default: all sheets when loading, names(list) when saving
row_names	Set first column as rownames or write rownames from each df, default: FALSE
...	further arguments passed to read.xlsx or write.xlsx
list_of_df	list of data.frames to write into excel workbook

mathosi/jj documentation built on Feb. 25, 2024, 2:29 p.m.