saveWorkbook: save Workbook to file

In openxlsx: Read, Write and Edit xlsx Files

save Workbook to file

Description

save a Workbook object to file

Usage

saveWorkbook(wb, file, overwrite = FALSE, returnValue = FALSE)

Arguments

wb	A Workbook object to write to file
file	A character string naming an xlsx file
overwrite	If TRUE, overwrite any existing file.
returnValue	If TRUE, returns TRUE in case of a success, else FALSE. If flag is FALSE, then no return value is returned.

Author(s)

Alexander Walker, Philipp Schauberger

See Also

createWorkbook()

addWorksheet()

loadWorkbook()

writeData()

writeDataTable()

Examples

## Create a new workbook and add a worksheet
wb <- createWorkbook("Creator of workbook")
addWorksheet(wb, sheetName = "My first worksheet")

## Save workbook to working directory
## Not run: 
saveWorkbook(wb, file = "saveWorkbookExample.xlsx", overwrite = TRUE)

## End(Not run)

openxlsx documentation built on Feb. 16, 2023, 6:47 p.m.