removeSheet-methods {XLConnect} | R Documentation |
Removes a worksheet from a workbook
.
## S4 method for signature 'workbook,character' removeSheet(object,sheet) ## S4 method for signature 'workbook,numeric' removeSheet(object,sheet)
object |
The |
sheet |
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 workbook
.
Also note that deleting worksheets may result in invalid name references.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, createSheet
,
existsSheet
, getSheets
,
renameSheet
, cloneSheet
,
setActiveSheet
# 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")