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.
- Steve Mullarkey, Australia
I think I've been spoiled by TMS. IMO TMS blows away everyone in terms of components offered for Delphi...
- Jeremy Fisher via TMS newsgroup
For some time now I am registered user of your TMS component pack. I haven't used all of them yet, but I am very satisfied with the one I have used for now. Of course, TAdvStringGrid is a pearl, but also the smaller ones like CABFile and ShellDlg are real time savers.
- Marc Vankeer, Belgium
We use TAdvStringGrid in all our C++Builder applications, which are used in over 55 countries worldwide, and we find it invaluable. TAdvStringGrid is flexible and full of great features, yet remains easy to use and represents exceptional value for money. We have found that TAdvStringGrid is continually developing and having useful new features added, and when we require support, the TMS Software Team are always quick to answer our questions with advice and code examples. We really do find TAdvStringGrid an excellent product and would recommend it to anyone.
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.
