save Workbook to file — saveWorkbook • openxlsx

save a Workbook object to file

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.

See also

createWorkbook()

addWorksheet()

loadWorkbook()

writeDataTable()

Author

Alexander Walker, Philipp Schauberger

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
if (FALSE) { # \dontrun{
saveWorkbook(wb, file = "saveWorkbookExample.xlsx", overwrite = TRUE)
} # }