Export > Excel export > Exporting to Excel

Exporting data to Excel format

Besides exporting as text file in CSV format easily opened by Excel, the PdxEditor also exports into native Excel format files.

In order to free the export feature from preconditions of installed MS Office Excel components, the chosen Excel version is kept at the basic version 2 format, readily opened by Excel or other spreadsheets and easily converted to later versions if needed.

Exports to Excel includes any text as well as all types of numerics, also including Memo and FmtMemo data. Bytes are exported as hexadecimals.

Binary fields are not exported, but non-empty fields are in the exported Excel file marked as e.g. <BLOB>, <Graphic>, <TypedBinary>, <OLE>, etc.

For transformation of line breaks i Memo texts - see Line breaks in Memos to <br> menu item on the Export menu.