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:

inputoutput
binarytable

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