getTables: List Excel tables in a workbook

Description Usage Arguments Value Examples

Description

List Excel tables in a workbook

Usage

1
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

1
2
3
4
5
6
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")

awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.