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

delphi excel export components export-to-excel
too picture too · Aug 11, 2010 · Viewed 10.2k times · Source

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

Germán Estévez -Neftalí- picture Germán Estévez -Neftalí- · Aug 11, 2010

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:

Check components: mxExports and mxNativeExcel.

Regards.

Related questions

Exporting to excel from Delphi without having excel

I'm looking to export data to excel from Delphi without having to own a copy of excel, is this possible? N.B. CSV will not do.

Read More
Ole 800A03EC error when using TExcelWorkBook SaveAs method in Delphi 7

I am trying to open excel 2003 workbook and save it as something else, for example excel 95. I use the following code: XLSApp:=TExcelApplication.Create(Self); XLSApp.Workbooks.Open(SomeFileName,NULL,false,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,…

Read More
Import data from Excel

I want to import data from Excel into a Paradox database on Delphi 7. How can I do that using Delphi?

Read More