getSheets-methods: Querying available worksheets in a workbook

In XLConnect: Excel Connector for R

Querying available worksheets in a workbook

Description

Returns all worksheet names in a workbook.

Usage

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

Arguments

object

The workbook to use

Author(s)

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

See Also

workbook, createSheet, removeSheet, renameSheet, getSheetPos, setSheetPos

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 available worksheets
sheets <- getSheets(wb)

## End(Not run)

XLConnect documentation built on Feb. 16, 2023, 5:53 p.m.