loadWorkbook: Load an existing .xlsx file

Description Usage Arguments Value Author(s) See Also Examples

Description

loadWorkbook returns a workbook object conserving styles and formatting of the original .xlsx file.

Usage

1
loadWorkbook(file, xlsxFile = NULL, isUnzipped = FALSE)

Arguments

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

Value

Workbook object.

Author(s)

Alexander Walker

See Also

removeWorksheet

Examples

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)

awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.