get_excel_tables: List Excel tables in a workbook
In Technomics/costmisc: Misc costverse functions
View source: R/read_functions_excel.R
get_excel_tables R Documentation
List Excel tables in a workbook
Description
get_excel_tables() is similar to getTables() but
returns more information.
Usage
get_excel_tables(wb, sheets = NULL)
Arguments
wb
A workbook object
sheets
Character vector of sheet names to list tables from. If NULL,
lists all sheets.
Value
A tibble with the worksheet, table name, and cell references.
See Also
Other Read Excel tables:
read_excel_table()
Examples
example_file <- system.file("examples/excel_examples.xlsx", package = "costmisc")
wb <- openxlsx::loadWorkbook(example_file)
get_excel_tables(wb)
Technomics/costmisc documentation built on Nov. 12, 2024, 8:05 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
View source: R/read_functions_excel.R
| get_excel_tables | R Documentation |
List Excel tables in a workbook
Description
get_excel_tables() is similar to getTables() but
returns more information.
Usage
get_excel_tables(wb, sheets = NULL)
Arguments
wb |
A workbook object |
sheets |
Character vector of sheet names to list tables from. If |
Value
A tibble with the worksheet, table name, and cell references.
See Also
Other Read Excel tables:
read_excel_table()
Examples
example_file <- system.file("examples/excel_examples.xlsx", package = "costmisc")
wb <- openxlsx::loadWorkbook(example_file)
get_excel_tables(wb)
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.