Description Usage Arguments Value Author(s) See Also Examples
loadWorkbook returns a workbook object conserving styles and formatting of the original .xlsx file.
1 | 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
1 2 3 4 5 6 7 8 9 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.