Load an existing .xlsx file
loadWorkbook returns a workbook object conserving styles and formatting of the original .xlsx file.
loadWorkbook(file, xlsxFile = NULL, isUnzipped = FALSE)
file |
A path to an existing .xlsx or .xlsm file |
xlsxFile |
alias for file |
isUnzipped |
Set to TRUE if the xlsx file is already unzipped |
Workbook object.
Alexander Walker
## load existing workbook from package folder
wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx"))
names(wb) # list worksheets
wb ## view object
## Add a worksheet
addWorksheet(wb, "A new worksheet")
## Save workbook
## Not run:
saveWorkbook(wb, "loadExample.xlsx", overwrite = TRUE)
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.