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.
See also
Other dtable:
as_tibble.harbour_dtable(),
hb_asset_path(),
hb_dtable(),
hb_read_csv(),
hb_read_dtable(),
hb_validate_dtable(),
hb_write_csv(),
hb_write_dtable(),
hb_write_xlsx(),
is_harbour_dtable(),
length.harbour_dtable(),
names.harbour_dtable(),
print.harbour_dtable(),
summary.harbour_dtable()
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)
