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.
  • --noheaders, -n: Don't treat the first row as column names.
  • --first-row, -f {int}: The row to start reading the sheets from. By default, reading starts from the firsts non empty row.
  • --prefer-integers, -i: Convert whole-number floats (for example, 40.0) to integers, leaving non-whole floats unchanged.

Input/output types:

inputoutput
binaryrecord

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] --noheaders