renameSheet-methods {XLConnect} | R Documentation |
Renaming worksheets from workbooks
Description
Renames a worksheet from a workbook
.
Usage
## S4 method for signature 'workbook,character'
renameSheet(object,sheet,newName)
## S4 method for signature 'workbook,numeric'
renameSheet(object,sheet,newName)
Arguments
object |
The |
sheet |
The name or index of the sheet to rename |
newName |
The new name of the sheet |
Note
Note that renaming worksheets may result in invalid name references.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
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")
## End(Not run)
[Package XLConnect version 1.0.10 Index]