Reading Excel spreadsheets with Delphi

delphi export-to-excel import-from-excel
Bruce McGee picture Bruce McGee · Mar 17, 2010 · Viewed 24.9k times · Source

I need to read from and write to Excel spreadsheets using Delphi 2010. Nothing fancy. Just reading and writing values from specific cells and ranges on different sheets. Needs to work without having Excel installed and support Excel 2007.

Some things I've looked at:

  • I've tried using ADO, which works OK for selecting everything in an entire sheet, but I haven't had much luck reading specific cells or ranges.

  • NativeExcel looked promising, but it doesn't seem to be in active development, and they don't respond to e-mails.

  • Axolot has a couple of products. The main product seems to be very functional, but is pricey. They have a lite version, but it doesn't support Delphi 2010.

Any recommendations? Free would be great, but I'm open to a commercial solution as long as it's reliable and well supported.

Answer

RichardS picture RichardS · Mar 17, 2010

TMS Flexcel - I know it looks like a reporting component for Excel (which it does very well and is a very handy tool to have in your toolkit) but it also includes components for reading and displaying Excel files. I've been very impressed with how well Adrian Gallero seems to know the Excel API, including Excel 2007.

http://www.tmssoftware.com/site/flexcel.asp

Not free of course, but at 75 Euros I think it's good value.

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
export delphi stringgrid to excel

I'm trying to export data from a stringgrid in delphi 7 to microsoft excel. I have been using this code to do it: objExcel := TExcelApplication.Create(nil); objExcel.Visible[LOCALE_USER_DEFAULT] := true; objWB := objExcel.workbooks.add(null,LOCALE_USER_DEFAULT); …

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

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 …

Read More