getActiveSheetIndex-methods {XLConnect}R Documentation

Querying the active worksheet index

Description

Queries the index of the active worksheet in a workbook.

Usage

## S4 method for signature 'workbook'
getActiveSheetIndex(object)

Arguments

object

The workbook to use

Author(s)

Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com

See Also

workbook, getActiveSheetName

Examples

# mtcars xlsx file from demoFiles subfolder of package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(demoExcelFile)

# Query the active sheet index
activeSheet <- getActiveSheetIndex(wb)

[Package XLConnect version 0.2-7 Index]