Read Excel tables

read_excel_table() reads a table object from an Excel workbook.

read_excel_table(wb, table_name, table_df = NULL)

Arguments

wb

A workbook object

table_name

A character name of a table to read.

table_df

A dataframe of table references, built using get_excel_tables(). If NULL the table will be built.

Value

A tibble with the table.

See also

Other Read Excel tables: get_excel_tables()

Examples

example_file <- system.file("examples/excel_examples.xlsx", package = "costmisc")

wb <- openxlsx::loadWorkbook(example_file)
head(read_excel_table(wb, "tbl_mtcars"))
#>               Model  mpg cyl disp  hp drat    wt  qsec vs am gear carb
#> 1         Mazda RX4 21.0   6  160 110 3.90 2.620 16.46  0  1    4    4
#> 2     Mazda RX4 Wag 21.0   6  160 110 3.90 2.875 17.02  0  1    4    4
#> 3        Datsun 710 22.8   4  108  93 3.85 2.320 18.61  1  1    4    1
#> 4    Hornet 4 Drive 21.4   6  258 110 3.08 3.215 19.44  1  0    3    1
#> 5 Hornet Sportabout 18.7   8  360 175 3.15 3.440 17.02  0  0    3    2
#> 6           Valiant 18.1   6  225 105 2.76 3.460 20.22  1  0    3    1