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
Greatgreatgreat news, this was fast again!! Thanks to all the people at TMS for their continuous hard work for the Delphi world! I think without your TMS Component Pack and without your fast reactions in nearly every situation (new Delphi-Releases, fixing issues in TMS components, handling support questions etc...) I had left the Delphi world years ago.
TMS really rocks, keep up with the very good work!
- Udo Treichel via email
Thanks for the effort to create the VCL grid goodies !
These chunks of outcome-oriented teaching-material are very useful.
It's unbelievable how powerful the grid is when one knows how to unveil it's countless options...
- Feichtenschlager Thomas
First of all congratulations! You're are doing very good work with your components. I discovered your TAdvStringGrid a few days ago and I can't think of using any other grid anymore in my programs.
- Pedro Panos, Spain
Thanks, you have the best support I have experienced!