Convert XLTM to DBF
Turn XLTM 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 XLTM files on the dialor turn it to pick what to do
One table for each sheet of your template.Each sheet becomes its own dBASE III table, with the first row as field names.
What you get
One DBF file for each sheet in the XLTM file, hidden sheets included. Formulas are written as their last results, so the table holds values, not formulas.
The first row of a sheet becomes the field names. Numbers, dates and true/false values become typed fields. Other cells become text.
What changes
Field names are cut to 10 Latin letters, digits and underscores. If none are left, the field is named FIELD1 and so on.
Text cells hold up to 254 bytes. They are written in the Windows code page that fits the text, or in UTF-8 when none does.
XLTM and DBF.What each format is.
The formats
Excel Macro-Enabled Template
An Excel template with macros enabled.
- Extensions
- .xltm
- MIME type
- application
/vnd .ms -excel .template .macroEnabled .12 - 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 XLTM to DBF conversion through the API, for your app or your agent.
$ cv convert report.xltm report/ --to dbf$ cv convert report.xltm report/ --to dbfQuestions.What people ask about XLTM to DBF.
Yes. Each sheet becomes its own dBASE III table, and hidden sheets are included. The result is one or more files.
They are written as their last results. The DBF file holds those values, not the formulas.
The first row of each sheet gives the field names. They are cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.
Yes. Text cells hold up to 254 bytes. The encoding is the Windows code page that fits, or else UTF-8.