appendWorksheet-methods | R Documentation |
Appends data to worksheets of a workbook
.
## S4 method for signature 'workbook,ANY,character' appendWorksheet(object,data,sheet,header,rownames) ## S4 method for signature 'workbook,ANY,numeric' appendWorksheet(object,data,sheet,header,rownames)
object |
The |
data |
Data to append |
sheet |
The name or index of the sheet to append the |
header |
Specifies if the column names should be written. The default is |
rownames |
Name ( |
Appends data
to the worksheet specified by sheet
. Data will be appended at the
bottom and left most column containing some data. If more complex "appending schemes" are required
you may make direct use of writeWorksheet
.
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
,
writeWorksheet
,
readWorksheet
,
writeNamedRegion
,
appendNamedRegion
,
readNamedRegion
## Not run: # mtcars xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(demoExcelFile) # Append mtcars data set to worksheet named 'mtcars' appendWorksheet(wb, mtcars, sheet = "mtcars") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.