getActiveSheetIndex-methods

Querying the active worksheet index

Queries the index of the active worksheet in a '>workbook.

Usage

# S4 method for workbook
getActiveSheetIndex(object)

See Also

'>workbook, getActiveSheetName

Aliases

• getActiveSheetIndex
• getActiveSheetIndex-methods
• getActiveSheetIndex,workbook-method

Examples

# NOT RUN {
# 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)
# }