appendNamedRegion-methods
Appending data to a named region
Appends data to an existing named region.
Usage
# S4 method for workbook,ANY
appendNamedRegion(object,data,name,header,rownames)Arguments
- object
- data
Data to write
- name
Name of the (existing) named region to which to append the
data- header
Specifies if the column names should be written. The default is
FALSE.- rownames
Name (
character) of column to use for the row names of the provideddataobject. If specified, the row names of the data object (data.frame) will be included as an additional column with the specified name. Ifrownames = NULL(default), no row names will be included.
Details
Appends data to the existing named region specified by name. The data is
appended at the bottom of the named region. See writeNamedRegion
for further information on writing named regions.
Note
Named regions are automatically redefined to the area occupied by the
previous and the newly appended data. This guarantees that the complete set
of data can be re-read using readNamedRegion.
Note however, that no checks are performed to see whether the appended data has the
same shape/structure as the previous data.
See Also
'>workbook,
writeNamedRegion,
readNamedRegion,
writeWorksheet,
appendWorksheet,
readWorksheet
Examples
# 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 named region named 'mtcars'
appendNamedRegion(wb, mtcars, name = "mtcars")
# }