XLConnect (version 0.1-3)

writeWorksheetToFile: Writing data to worksheets in an Excel file (wrapper function)

Description

Writes data to worksheets in an Excel file.

Usage

writeWorksheetToFile(file, styleAction = XLC$STYLE_ACTION.XLCONNECT, 
...)

Arguments

file

The path name of the file to write to.

...

Arguments passed on to writeWorksheet

styleAction

Style action to be used when writing the data - not vectorized! The default is XLC$STYLE_ACTION.XLCONNECT. See setStyleAction for more information.

See Also

writeWorksheet, writeNamedRegionToFile, readWorksheetFromFile, readNamedRegionFromFile

Examples

# multiregion xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/multiregion.xlsx",
                             package = "XLConnect")

# create a copy of the template
template <- "template-ws.xlsx"
file.copy(demoExcelFile, template) 

# Write single data.frame to a specified location in an existing file
writeWorksheetToFile(template, data=iris, sheet="FirstSheet",
                     startRow=9, startCol = 9)

# create a copy of the template
template <- "template-multi-ws.xlsx"

# Write a few copies of the data.frame all over a new file
writeWorksheetToFile(template, data = list(i1 = iris, i2 = iris, i3 = iris),
                     sheet = c("FirstSheet", "SecondSheet", "FirstSheet"),
                     startRow = c(1,101,201), startCol = c(1,11,21))