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
Thank you for such a wonderful product. I can't believe I've been using other stringgrids for so long.
- Kevin Tupper, US
Purchasing the component pack was a fantastic deal that I do not regret. You are always adding great features and enhancements and it is much appreciated. Thank You!
- John Mondry, US
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
I am very impressed with the flexibility of your DBPlanner. As I am just writing a test application to make sure all work as I planned, it does so far. I tried VisualPlanIt and could not get the same flexibility. None of the other components suggested does the things the same way.