Convert STC to DBF
Turn STC 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 STC files on the dialor turn it to pick what to do
Each sheet becomes a dBASE table.Hidden sheets are included, and formulas arrive as their last results.
What you get
One dBASE III table for each sheet in the template, hidden sheets included. A workbook with several sheets gives you several DBF files.
The first row of each sheet becomes the field names. Formulas are written as the last result they showed, not as the formula.
How fields are typed
Numbers, dates and true/false values become typed fields. Every other cell becomes a text field of up to 254 bytes. The text is written in the Windows code page that fits it, or in UTF-8 when none does.
How names are cut
Field names are cut to 10 characters, using Latin letters, digits and underscores. When no usable characters are left, the field is named FIELD1 and so on.
Because of the cut, long headings in the first row will not appear in full. Check the field names if you need to match them against another table. For other routes from this format, see every STC conversion, or see every DBF conversion.
STC and DBF.What each format is.
The formats
OpenOffice.org 1.0 Spreadsheet Template
A Calc template from OpenOffice.org 1.x and StarOffice 6 and 7.
- Extensions
- .stc
- MIME type
- application
/vnd .sun .xml .calc .template - 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 STC to DBF conversion through the API, for your app or your agent.
$ cv convert report.stc report/ --to dbf$ cv convert report.stc report/ --to dbfQuestions.What people ask about STC to DBF.
Yes. Each sheet, hidden ones included, becomes its own dBASE III table.
No. Each formula is written as its last result, so the DBF holds values only.
It becomes the field names. They are cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.
Text is stored in fields of up to 254 bytes. It uses the Windows code page that fits, or UTF-8 when none does.