Convert SXC to DBF
Turn SXC documents into DBF files. Each sheet, hidden ones included, becomes its own dBASE III table with formulas as their last results and the first row as field names, cut to 10 Latin letters, digits and underscores (FIELD1 and so on when none are left).
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 dBASE table for each sheet.Every sheet in the SXC file becomes its own DBF table, hidden sheets included.
What you get
Each sheet is written as a dBASE III table, so a workbook with several sheets gives you several DBF files. Formulas are saved as their last results, not as formulas.
The first row of each sheet becomes the field names. Numbers, dates and true/false values become typed fields.
How names and text are handled
Field names are cut to 10 characters, using Latin letters, digits and underscores. When none are left, the field is named FIELD1 and so on.
Other cells are stored as text of up to 254 bytes. The text uses the Windows code page that fits, or UTF-8 if none does.
SXC and DBF.What each format is.
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
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
In your code.The same SXC to DBF conversion through the API, for your app or your agent.
$ cv convert report.sxc report/ --to dbf$ cv convert report.sxc report/ --to dbfQuestions.What people ask about SXC to DBF.
Yes. Hidden sheets become their own tables like the others.
No. Each formula is stored as its last result.
It becomes the field names. They are cut to 10 Latin letters, digits and underscores.
No. Each sheet becomes its own DBF table, so you get one file per sheet.