Convert DGN to XLSX
Turn DGN documents into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop DGN files on the dialor turn it to pick what to do
A spreadsheet with one row per feature.Each shape is written as WKT, and each attribute gets its own column.
What you get
A workbook with one sheet, named after the file and cut to 31 characters. Each feature in the DGN becomes one row.
The first column is named WKT and holds the feature's shape as WKT text. Every attribute follows as its own column, with numbers, dates and true and false values written as typed cells.
What changes
Features without a geometry keep their row, and the WKT cell is empty. If the file already has an attribute named WKT, that column is renamed WKT_1.
Lists and nested values become JSON text. Times with a time zone are written in UTC.
Limits
A cell holds at most 32,767 characters. If a shape is longer than that, its WKT cell is left empty and a warning is given.
A map of more than 1,048,575 features fails with
resource_limit. To work with several workbooks as one, try merge XLSX.
DGN and XLSX.What each format is.
The formats
MicroStation Design
MicroStation V7 design files, the CAD drawings of road, rail and utility engineering.
- Extensions
- .dgn
- MIME type
- image
/vnd .dgn - Kind
- Documents
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
In your code.The same DGN to XLSX conversion through the API, for your app or your agent.
$ cv convert report.dgn report.xlsx$ cv convert report.dgn report.xlsxQuestions.What people ask about DGN to XLSX.
It takes the name of the file, cut to 31 characters. The workbook holds only this one sheet.
It is in the first column, named WKT, as WKT text. Features without a geometry have an empty cell there.
Its row is kept. The WKT cell is empty and its attributes are still written.
It stops with resource_limit when the map has more than 1,048,575 features.