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 would like to congratulate you and the team with an excellent set of components and customer service with no equal. I have bought a few subscription packages from other component manufacturers as well and I must say that TMSSoftware surpasses them all by your speedy and frequent releases and activity on your products.
I actually can't keep up with the releases and new features you keep on adding to your products. It is good to know that there is a component manufacturer who are as serious about their customers as we are about ours.
- Markus Venter via email
I work with Delphi since the first version, and searching for components is a hard work (I think you know). I've tested tons of components, even the "best-sellers", in my eyes, there are two things importants to look for a component: the "look" (for visual components of course), and the most important:
It need to be easy to understand, to programming, and to find information when it is needed (help/manual/demos)
In all of these points your job is really good! Congratulations for you and your team.
- Luiz Nelson S Gonçalves, Brasil 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.
- Giorgio Biondi
TMS GUIMotions deeply impressed me. With GUIMotions I have all I need very fast, reasonably cheap and completely native.
I just want to say thank you to these great guys in this company and write my opinion about this component for others.