Learn R Programming

XLConnect (version 1.1.0)

getActiveSheetName-methods: Querying the active worksheet name

Description

Queries the name of the active worksheet in a workbook.

Usage

# S4 method for workbook
getActiveSheetName(object)

Arguments

object

The workbook to use

Author

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See Also

workbook, getActiveSheetIndex

Examples

Run this code
if (FALSE) {
# 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)
}

Run the code above in your browser using DataLab