List Excel tables in a workbook
getTables(wb, sheet)A workbook object
A name or index of a worksheet
character vector of table names on the specified sheet
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")
#> [1] "Table3" "mtcars"
#> attr(,"refs")
#> [1] "A1:E151" "J1:T33"