from ods
For formats.
Parse OpenDocument Spreadsheet(.ods) data and create table.
Command Type
built-in
Signature
> from ods {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:
| input | output |
|---|---|
| binary | record |
Examples
Convert binary .ods data to a table.
> open --raw test.ods | from ods
Convert binary .ods data to a table, specifying the tables.
> open --raw test.ods | from ods --sheets [Spreadsheet1]
Convert binary .ods data to a table, specifying the tables and specifying no header row.
> open --raw test.ods | from ods --sheets [Spreadsheet1] --noheaders
Ported from nushell/nushell.github.io. Copyright (c) 2021 Nushell Project. MIT License.