I was very impressed with the speed of your grid as some of the files being loaded are > 30000 rows, the performance is still very good. Although I don't use many of the newer advanced features I have found it to be a very solid work horse.
- Huw Reddick, UK
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
Once again - thanks guys! I am truly impressed with the prompt replies to my many questions and comments. I have been so impressed with each and every functionality of every one of the TMS components I have used in my application. With your components added capability, Borland seriously needs to think about packaging your product with Delphi instead of their own. Keep up the awesome work!!
- James Rue, USA
I am a registered user of several TMS software packages. For the longest time I have been using the TMS Grid to do everything that the TStringGrid never could think of doing. At work we ran into a problem that would require some features that would have taken me hours and hours to implement by myself on a TStringGrid (I am the only developer in my group) and we really had no time or anyone to pay for it. That was when I suggested the TAdvGrid. We immediately bought the whole component pack. That was back last December. Ever since then, we've used and reused the product over and over again in many different projects and have saved a great deal of money as well as time by it's use. My boss has been even more impressed by the fact that every update includes newer and better updates.
- Joseph Wilcock via email
It is easy to use and powerful. I use it in cosole vb.net apps focused on reporting and calculation and it is fast in generating files. The feature of reporting by tags or "direct reporting" once known is a fundamental shortcut in report creation.
Not only it is fast, but also powerful and I can say this because I use it integrated with sql server: download data from sql, apply complex calculation by an excel template hand-defined in Excel, convert to values and upload back to sql server.
Size of this is about 60K rows X 70 columns X 6 (separate files). It works, obviously it consumes almost all the available 4 gb ram but it works even in 32bit mode.
When I use Flexcel I feel myself as I was driving a powerful sport car. Thank you very much.
