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
3 minutes from submission of support question to supply of answer. Now how slow is that ? :) :) ;) I seriously just don't think you guys can get any better at this !!! ... I'm starting my weekend stunned !
- Pete Barrett via email
I appreciate all the time and effort you guys put into maintaining and enhancing this great suite of components. Though I only really start again using Delphi after some years "off track" with a new project I am working on, using them really saves me lots of time as I can have a sexy looking interface with great usability without needing to "draw" this myself from standard components. Big win!
- Matthias Böge via TMS Forum
In case it helps anybody, the component I found is TAdvStringGrid. It does all I wanted and much more. I was getting useful results within 2 hours of downloading it. Some of the additional features I hadn't thought of but have used anyway. The application has a significantly improved interface inside 1 day.
- Steve Mullarkey, Australia
TAdvStringGrid is the most fabulous grid I've ever had.
