Description Usage Arguments Details Author(s) See Also Examples
Queries the available Excel tables on the specified worksheet.
1 2 3 4 |
object |
The |
sheet |
Index ( |
simplify |
|
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.
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, getSheets
,
readTable
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.