getSheets-methods: Querying available worksheets in a workbook

Description Usage Arguments Author(s) See Also Examples

Description

Returns all worksheet names in a workbook.

Usage

1
2
## 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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
## 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)

Example output

OpenJDK 64-Bit Server VM warning: Can't detect primordial thread stack location - find_vma failed
XLConnect 1.0.1 by Mirai Solutions GmbH [aut],
  Martin Studer [cre],
  The Apache Software Foundation [ctb, cph] (Apache POI),
  Graph Builder [ctb, cph] (Curvesapi Java library)
http://www.mirai-solutions.com
https://github.com/miraisolutions/xlconnect

XLConnect documentation built on Oct. 1, 2021, 5:06 p.m.