createSheet-methods
From XLConnect v1.0.1
by Martin Studer
Creating worksheets in a workbook
Usage
# S4 method for workbook
createSheet(object, name)
Arguments
Details
Creates a worksheet with the specified name
if it does not
already exist. Note that the naming of worksheets needs to be in line
with Excel's convention, otherwise an exception will be thrown. For
example, worksheet names cannot be longer than 31 characters. Also note
that the name
argument is vectorized, so multiple worksheets can
be created in one method call.
See Also
'>workbook
, removeSheet
,
renameSheet
,
existsSheet
, getSheets
,
cloneSheet
Examples
# NOT RUN {
# Load workbook (create if not existing)
wb <- loadWorkbook("createSheet.xlsx", create = TRUE)
# Create a worksheet called 'CO2'
createSheet(wb, name = "CO2")
# Save workbook (this actually writes the file to disk)
saveWorkbook(wb)
# clean up
file.remove("createSheet.xlsx")
# }
Community examples
Looks like there are no examples yet.