removeSheet-methods

0th

Percentile

Removing worksheets from workbooks

Removes a worksheet from a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
removeSheet(object,sheet)
# S4 method for workbook,numeric
removeSheet(object,sheet)
Arguments
object

The '>workbook to use

sheet

The name or index of the sheet to remove

Note

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.

See Also

'>workbook, createSheet, existsSheet, getSheets, renameSheet, cloneSheet, setActiveSheet

Aliases
  • removeSheet
  • removeSheet-methods
  • removeSheet,workbook,character-method
  • removeSheet,workbook,numeric-method
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)

# Remove the worksheet called 'mtcars' from the above file
removeSheet(wb, sheet = "mtcars")
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.