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
"Personally I have been using your component products for Borland since at least 1998. Since then I've been in various positions to influence corporate development direction and TMS has always been on the "must have" list.
Seeing as how in the past 11 years I have only needed to contact support once and use the forums twice speaks volumes to the quality of the products that you produce."
- Erik Wolowitz via email
VCL Component Studio is AWESOME and the components are used every single day!
- David Case via email
I have installed the beta and compiled our app with it and no issues
Thanks for such a great product and excellent support.
- Andrew Cumming
I've worked with Flexcel for the last two years and this is one of the greatest products I have ever had the pleasure of working with. It is FAST and it just plain works! They are super responsive in answering questions and they've even added features I've requested. If you need to generate reports, don't shell out money for Crystal (or whatever name it goes by this month) - Buy this and you will NOT be sorry.