openxlsx (version 1.0.3)

loadWorkbook: Load an exisiting .xlsx file

Description

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

Usage

loadWorkbook(xlsxFile)

Arguments

xlsxFile

A path to an existing .xlsx file

Value

• Workbook object.

See Also

removeWorksheet

Examples

## load existing workbook from package folder
wb <- loadWorkbook(xlsxFile = system.file("loadExample.xlsx", package= "openxlsx"))
sheets(wb)  #list worksheets
wb ## view object
## Add a worksheet
addWorksheet(wb, "A new worksheet")

## update data in Sales worksheet
df <- data.frame("Orders" = round(runif(10)*200),
                 "TotalSales" = runif(10)*400)
writeData(wb, "Sales", df, xy=c("A", 2))

## Save workbook
saveWorkbook(wb, "loadExample.xlsx", overwrite = TRUE)