View source: R/writeWorksheetToFile.R
writeWorksheetToFile | R Documentation |
Writes data to worksheets in an Excel file.
writeWorksheetToFile(file, data, sheet, ..., styleAction = XLC$STYLE_ACTION.XLCONNECT, clearSheets = FALSE)
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 |
clearSheets |
TRUE to clear sheets before writing data. |
Thomas Themel
Mirai Solutions GmbH https://mirai-solutions.ch
writeWorksheet
,
writeNamedRegionToFile
,
readWorksheetFromFile
,
readNamedRegionFromFile
## 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)) # clean up file.remove("template-multi-ws.xlsx") file.remove("template-ws.xlsx") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.