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 am very happy with you product, it meets just about all of my needs and is great value for money.
- Mike Hamilton
Thank you for this superb tool collection!
- Henning Swiboda
The additional facilities the new version of the grid has given me has been a godsend, well worth the asking price and keep up the good work. Also, it's great to see and author responding to users questions so quickly. There's a few companies I've bought components from who should take a lesson from you in customer service.
- Kenvyn Davies, UK via email
It's now very easy to build a report with the new Flexcel + Aurelius integration. It was so easy that I really thought I was doing something wrong. I will never go back to a report generator, Flexcel is way cooler and easier for reports
