Another vote for Flexcel here, since the rewritten and updated Flexcel came out a year or two ago, I only use that. Mostly I use it to read XLS and XLSX files, which it does much faster and more flexibly than Excel automation, in my experience. If you also need to write XLS and XLSX files (which I do occasionally) Flexcel has the most amazing utility named 'ApiMate'. You can design your output report in Excel, including only a minimum of actual data, but with all the detailed formatting, headings, and column, row and cell properties you need. Then point ApiMate at the Excel file, and it generates a Delphi program to write the entire XLS file using the Flexcel API, with all the attributes matching those you created in Excel itself. It is then the work of a few moments to adapt the ApiMate-created functions to handle your real data. Magic! Flexcel support is prompt and helpful, too.
- Tim Frost
I think I've been spoiled by TMS. IMO TMS blows away everyone in terms of components offered for Delphi...
- Jeremy Fisher via TMS newsgroup
As always, I truly appreciate your components and your great support. I would also like to let you know that there hasn't been a project that I havn't used one of your components since my purchase... A great value at $95
- Kelly Tremblay, Jefferson National Labn, US
I am a very happy user of your grid pack, the amount of properties is overwhelming! That is the only disadvantage (?)....(!)
Keep on doing this good customer support.
- Joost Geluk/Tradinco via email
Wow ! I just got the TMS FlexCel and it worked right away. After a few tries I had an Excel file. First I thought it didn't work because it was so fast. It took 55 seconds with TExcelApplication, but with the TXLSAdapter it took about 0 seconds. I couldn't click on my stopwatch fast enough !! Great stuff ! Thanks a lot !