One table per worksheet. Like hb_read_csv(), this produces a new
base rather than restoring one.
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)