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 really impressed about your know-how around Excel's under the hood workings. I've been kicking the FlexCel API around a bit over the weekend and must say it is the best investment I made in a long time in both time and money! And the speed at which you guys respond is incredible !
- Tim Young
First, I've bought and have been using your component pack a while now, and I like it! I hardly use standard components anymore. So there's a feather in your cap. Congrats!
- Evert Haasdijk, KiQ
I don''t know how I could have created and managed so many projects without the AdvStringGrid! And although there is already so much functionality in it I''m using my own derived version with automatic column widths, enhanced export to Excel (including text colors, backround colors, comments, merged cells and more), the possibility to fill in static data at design time and more. This often allows me to build a new tool in hours instead of days! Support is also great! Thanks.
- Raß Jacqueline
All in all TAdvStringGrid works fine and is very powerfull in features. Support is excellent.
