from xlsx for formats
Parse binary Excel(.xlsx) data and create table.
Signature
> from xlsx {flags}
Flags
-
--sheets, -s {list<string>}: Only convert specified sheets. -
--header-row, -r {oneof<int, nothing>}: Specify row (0-indexed) to designate the header (default first non-empty row) or null for no header
Input/output types:
| input | output |
|---|---|
| binary | table |
Examples
Convert binary .xlsx data to a table.
> open --raw test.xlsx | from xlsx
Convert binary .xlsx data to a table, specifying the tables.
> open --raw test.xlsx | from xlsx --sheets [Spreadsheet1]
Convert binary .xlsx data to a table, specifying the tables and specifying no header row.
> open --raw test.xlsx | from xlsx --sheets [Spreadsheet1] --header-row null
Copyright © 2019–2026 The Nushell Project DevelopersLicensed under the MIT License.
https://www.nushell.sh/commands/docs/from_xlsx.html
