XLConnect (version 1.0.3)

getSheets-methods: Querying available worksheets in a workbook

Description

Returns all worksheet names in a '>workbook.

Usage

# S4 method for workbook
getSheets(object)

Arguments

object

The '>workbook to use

See Also

'>workbook, createSheet, removeSheet, renameSheet, getSheetPos, setSheetPos

Examples

Run this code
# 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 available worksheets
sheets <- getSheets(wb)
# }

Run the code above in your browser using DataCamp Workspace