oExport

oExport is especially designed for programmers who use Delphi and want to create Excel and ODS spreadsheets. The idea behind the tool is to provide a single solution that enables users to create, read and manage CVS, XLS, XLSX and ODS documents. As far as the compatibility with Delphi is concerned, the app works well with a wide range of compilers, from Delphi 5 to Delphi 10.4 and Lazarus.

The advantages that come with using the tool include that users no longer need external DLL libraries and that there are no dependencies on Excel or OpenOffice. The app comes with full Unicode support for non-unicode Delphi versions and users can import and export large tables without having to store the entire document in memory. Take note that the tool does not support charts, graphs or images and hence, users cannot view them in the exported files.

It is important to note that the layout properties are missing when an Excel document is opened in OpenOffice or ODS. While some may be tempted to consider this a bug of the app, the truth that the reason for this is that Excel does not read all ODS file properties, whereas OpenOffice experiences a similar problem with XLSX files.