setActiveSheet-methods

0th

Percentile

Setting the active worksheet in a workbook

Sets the active worksheet of a '>workbook.

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

The '>workbook to use

sheet

The name or index of the sheet to activate

Note

The active worksheet of a '>workbook is the worksheet that is displayed when the corresponding Excel file is opened.

See Also

'>workbook, createSheet, removeSheet, renameSheet, existsSheet, getSheets

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

# Sets the active sheet to the sheet 'mtcars3'
setActiveSheet(wb, sheet = "mtcars3")
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.