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 for such a good grid. There is no way I could have used any other grid for what my user wanted.
- Mark J. Brindle, Australia
Ich möchte Ihnen ein hammergroßes megafettes Lob aussprechen :) Ihre Komponenten sind nunmal einfach eine der besten. Ich bin sehr von Ihren Komponenten überzeugt. Ich programmiere damit sehr gerne.
- Michael Mangold, Germany
Very nice, you keep surprising for the best
- Yoav Berchik
Wow, I'm really impressed that you found this out in such a short time!
Thanks especially for testing it with Softmaker Office itself and with some more elaborate spreadsheets, this makes me confident that it'll work with the "real life" files that I have to handle.
Super service!
