renameSheet-methods
From XLConnect v1.0.2
by Martin Studer
Renaming worksheets from workbooks
Usage
# S4 method for workbook,character
renameSheet(object,sheet,newName)
# S4 method for workbook,numeric
renameSheet(object,sheet,newName)
Arguments
Note
Note that renaming worksheets may result in invalid name references.
See Also
'>workbook
, createSheet
,
existsSheet
, getSheets
,
removeSheet
, cloneSheet
,
setActiveSheet
Examples
# NOT RUN {
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")
# Load workbook
wb <- loadWorkbook(mtcarsFile)
# Rename the worksheet called 'mtcars' from the above file to 'MyCars'
renameSheet(wb, sheet = "mtcars", newName = "MyCars")
# }
Community examples
Looks like there are no examples yet.