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
Thanks, you have the best support I have experienced!
- Rob McCormack, US
Thank you Mr. Fierens for your time and assistance.
Just want to say your VCL Pack is fabulous.
- Mark Mihevc
I've just stumbled upon your component collection due to a mention (albeit a small one) in the Borland.com newsgroups. What can I say...I had just started really trying to use a simple TStringGrid. Upon finding your TAdvStringGrid I never looked back. What a FANTASTIC component.
- Cris Gallegos, US
We had a very positive Flexcel talk in our meeting yesterday. Dave Martel was very positive about the product; the support; speed to fix an issue.
By doing the talk he realised improvements over the years and has an amazing success story from analysing a large number of human created spreadsheets (1000’s of spreadsheets with 1000’s of readings).
The speed of analysis allowed them to refine and re-train the importer to deal with human vagaries (comments / colour etc).