| loadWorkbook {openxlsx} | R Documentation |
loadWorkbook returns a workbook object conserving styles and formatting of the original .xlsx file.
loadWorkbook(file, xlsxFile = NULL)
file |
A path to an existing .xlsx or .xlsm file |
xlsxFile |
alias for file |
Workbook object.
Alexander Walker
## load existing workbook from package folder
wb <- loadWorkbook(file = system.file("loadExample.xlsx", package= "openxlsx"))
names(wb) #list worksheets
wb ## view object
## Add a worksheet
addWorksheet(wb, "A new worksheet")
## Save workbook
saveWorkbook(wb, "loadExample.xlsx", overwrite = TRUE)