Convert SXC to PARQUET
Turn SXC documents into PARQUET files. One Parquet file per worksheet, named after it, hidden ones included; chart sheets and empty sheets are skipped.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SXC files on the dialor turn it to pick what to do
One Parquet file for each worksheet.Each sheet in your SXC spreadsheet becomes its own typed data file.
What you get
One Parquet file per worksheet, named after the sheet. Hidden worksheets are included. Chart sheets and empty sheets are skipped.
Each file takes its column names from the first row. Its column types come from the values in the columns below.
Formulas
Cells with formulas give their last computed values. The formulas themselves are not carried over.
Converting one sheet
Set Sheet to the name of a worksheet, or to its number counting from 1, and only that worksheet is converted. When Sheet is left out, every worksheet is converted.
To join the resulting files afterward, use merge PARQUET.
SXC and PARQUET.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
OpenOffice.org 1.0 Spreadsheet
Calc spreadsheets from OpenOffice.org 1.x and StarOffice 6 and 7, the XML format that OpenDocument grew out of.
- Extensions
- .sxc
- MIME type
- application
/vnd .sun .xml .calc - Kind
- Documents
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
In your code.The same SXC to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.sxc report/ --to parquet$ cv convert report.sxc report/ --to parquetQuestions.What people ask about SXC to PARQUET.
One Parquet file for each worksheet. Hidden worksheets count, while chart sheets and empty sheets do not.
From the first row of each worksheet. The types of the columns are taken from the values beneath it.
Yes. Set Sheet to its name or its number, counting from 1.
The file holds the last computed value of each formula.