getActiveSheetName-methods: Querying the active worksheet name

Description Usage Arguments Author(s) See Also Examples

Description

Queries the name of the active worksheet in a workbook.

Usage

1
2
## S4 method for signature 'workbook'
getActiveSheetName(object)

Arguments

object

The workbook to use

Author(s)

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

See Also

workbook, getActiveSheetIndex

Examples

1
2
3
4
5
6
7
8
# 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 name
activeSheet <- getActiveSheetName(wb)

XLConnect documentation built on May 29, 2017, 7:04 p.m.