openxlsx: getTables – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

getTables

List Excel tables in a workbook

Description

List Excel tables in a workbook

Usage

getTables(wb, sheet)

Arguments

`wb`	A workbook object
`sheet`	A name or index of a worksheet

Value

character vector of table names on the specified sheet

Examples

wb <- createWorkbook()
addWorksheet(wb, sheetName = "Sheet 1")
writeDataTable(wb, sheet = "Sheet 1", x = iris)
writeDataTable(wb, sheet = 1, x = mtcars, tableName = "mtcars", startCol = 10)

getTables(wb, sheet = "Sheet 1")

openxlsx

Read, Write and Edit xlsx Files

v4.2.3

MIT + file LICENSE

Authors

Philipp Schauberger [aut, cre], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb]

Initial release

2020-10-26