xlsimple (version 1.0.5)

saveXLworkbook: Save 'Excel' Workbook to disk

Description

Save 'Excel' Workbook to disk

Usage

saveXLworkbook(wbList, fname = "xl.Out.xlsx", timeStamp = FALSE, clean = TRUE)

Arguments

wbList

list with workbook and default cell styles (i.e., output from getXLsettings)

fname

'Excel' file name

timeStamp

Logical field to include date/time stamp in file name (TRUE [default]).

clean

Logical field indicating whether to remove original sheets in workbook

Value

n/a

Examples

Run this code
# NOT RUN {
XL.wb <- getXLsettings()
XL.wb <- addXLsheetStd(XL.wb, mtcars)
XL.wb <- addXLsheetStd(XL.wb, mtcars, "mtcars1")
XL.wb <- addXLsheetStd(XL.wb, mtcars, "mtcars2", "Standard mtcars data frame")
XL.wb$pName <- "ProjName" # optional, blank if not included
XL.wb$pDesc <- "ProjDesc" # optional, blank if not included
saveXLworkbook(XL.wb, file.path(tempdir(), 'myXLfile.xlsx'), timeStamp=FALSE, clean=FALSE)
saveXLworkbook(XL.wb, file.path(tempdir(), 'myXLfile.xlsx'), timeStamp=TRUE,  clean=FALSE)
saveXLworkbook(XL.wb, file.path(tempdir(), 'myXLfile.xlsx'), timeStamp=TRUE,  clean=TRUE)
saveXLworkbook(XL.wb, file.path(tempdir(), 'myXLfile.xlsx'))
# }

Run the code above in your browser using DataCamp Workspace