Open source component or unit for exporting Delphi TDataSet to native XLS without Excel installed

Question

Do you possibly know about the existence of a free and open sourced Delphi code to export TDataSet to native XLS format? The question was previously asked here, yet I am looking for a free solution.

As observed in for example TeeChart.TeeStore.TSeriesDataXLS.SaveToStream writing a native XLS export function is not a rocket science, yet I struggle to find an existing solution, which would definitely save some time and money (for commercial component which would be used in 10-20%).

It would be beneficial if such export code would allow color and text style changes, but for me personally it is not crucial.

Answer 1

I have used the components mxExport from Max. It's free and with source code avaible. The page it's now offline (http://www.maxcomponents.net/) but you can find the components in other places:

• Torry
• FTP ClubDelphi (all components libraries of Max)
• ...

Check components: mxExports and mxNativeExcel.

Regards.

Answer 2

give smExport a try. Not free, but reasonably priced with 35€ / 50 € (without/ with source). They also have a trial version (limited by the number of rows you can export). In addition it supports exports into lots of other formats.