XLConnect (version 0.2-9)

setActiveSheet-methods: Setting the active worksheet in a workbook

Description

Sets the active worksheet of a workbook.

Usage

## S3 method for class 'workbook,character':
setActiveSheet(object,sheet)
## S3 method for class 'workbook,numeric':
setActiveSheet(object,sheet)

Arguments

object

The workbook to use

sheet

The name or index of the sheet to activate

See Also

workbook, createSheet, removeSheet, renameSheet, existsSheet, getSheets

Examples

# 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")