Skip to contents

One table per worksheet. Like hb_read_csv(), this produces a new base rather than restoring one.

Usage

hb_read_xlsx(path, ..., sheets = NULL, base_name = "harbouR base")

Arguments

path

Path to an .xlsx file.

...

These dots are for future extensions and must be empty.

sheets

Worksheet names to read. Default: all of them.

base_name

Name recorded for the new base.

Value

A harbour_dtable, with the components hb_read_dtable() describes, holding one table per sheet read.

Details

A column's type follows its cells, judged over every row of the sheet. A column with no values at all is text. The spaces around a text value are kept. A column named _id, such as the one hb_write_xlsx() writes, is dropped, with a warning when it holds anything but SeaTable row ids.

Examples

path <- tempfile(fileext = ".xlsx")
writexl::write_xlsx(list(Samples = data.frame(x = 1:2)), path)
hb_read_xlsx(path)
#> 
#> ── <harbour_dtable> ────────────────────────────────────────────────────────────
#> • base : "harbouR base"
#> • tables : 1
#> • rows : 2
#> • assets : 0
#> 
#> - Samples (1 cols, 2 rows)
unlink(path)