getTables-methods {XLConnect} | R Documentation |
Querying available Excel tables in a workbook
Description
Queries the available Excel tables on the specified worksheet.
Usage
## S4 method for signature 'workbook,numeric'
getTables(object,sheet,simplify)
## S4 method for signature 'workbook,character'
getTables(object,sheet,simplify)
Arguments
object |
The |
sheet |
Index ( |
simplify |
|
Details
Since this is a vectorized function (multiple sheets can be specified) the result is a
named list (one component per sheet) if no simplification is applied. In cases where only
one sheet is queried and simplify = TRUE
(default) the result is simplified to a
vector.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
, getSheets
,
readTable
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 tables (table names) on sheet 'mtcars_table'
tables <- getTables(wb, sheet = "mtcars_table")
# ... or via sheet index
tables <- getTables(wb, sheet = 4)
## End(Not run)
[Package XLConnect version 1.0.10 Index]