saveWorkbook: save Workbook to file

Description Usage Arguments Author(s) See Also Examples

View source: R/wrappers.R

Description

save a Workbook object to file

Usage

1
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

1
2
3
4
5
6
7
8
9
## 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)

Example output

Note: zip::zip() is deprecated, please use zip::zipr() instead

openxlsx documentation built on June 16, 2021, 9:06 a.m.