removeSheet-methods: Removing worksheets from workbooks
Removes a worksheet from a
## S4 method for signature 'workbook,character'
## S4 method for signature 'workbook,numeric'
workbook to use
The name or index of the sheet to remove
When removing a worksheet that is the currently active sheet then XLConnect resets
the active sheet to the first possible worksheet in the
Also note that deleting worksheets may result in invalid name references.
Mirai Solutions GmbH http://www.mirai-solutions.com
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")
# Load workbook
wb <- loadWorkbook(mtcarsFile)
# Remove the worksheet called 'mtcars' from the above file
removeSheet(wb, sheet = "mtcars")