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 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
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
TMS Planner werkt flawless ! In het verleden heb ik met verschillende planbord componenten gewerkt en ik moet zeggen dat TMS ze allemaal overstijgt
- Hertwig van Zwietering, Nederland
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.