writeWorksheetToFile

0th

Percentile

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

Writes data to worksheets in an Excel file.

Keywords
IO
Usage
writeWorksheetToFile(file, data, sheet, ..., styleAction = XLC$STYLE_ACTION.XLCONNECT, 
clearSheets = FALSE)
Arguments
file

The path name of the file to write to.

data

Data to write

sheet

The name or index of the sheet to write to

...

Additional arguments passed 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.

clearSheets

TRUE to clear sheets before writing data.

See Also

writeWorksheet, writeNamedRegionToFile, readWorksheetFromFile, readNamedRegionFromFile

Aliases
  • writeWorksheetToFile
Examples
# NOT RUN {
# 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))

# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.