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
Wow, I'm really impressed that you found this out in such a short time!
Thanks especially for testing it with Softmaker Office itself and with some more elaborate spreadsheets, this makes me confident that it'll work with the "real life" files that I have to handle.
Super service!
- Arthur Hoornweg
Os components TMS são verdadeiras jóias, tanto por sua facilidade de uso como pelo excelente suport técnico provido pela aquipe de desenvolvedores. Vale a pena registrar !!!
- Fabio Marcos Euzebio - Brasil
TMS Aurelius makes my code to be very clean. I can code in pure OOP, not worrying about database persistence or SQL statements, being able to switch connections and database servers very easily. My development speed has increased significantly.
- Carlos Fitl
I am very excited about the data modeler and how well it creates the Aurelius script. I have just started learning Aurelius and with FMX UI components, Aurelius, the Data modeler and John's new book on MVVM in Delphi I look forward to the next couple of weeks! I believe this to be my breakthrough in producing better applications quicker. I come from a strong database modeling background but have never lost my love for programming. Up to now I always struggled to make the bridge to creating easy cool looking applications fast as I keep on getting tied down in the detail of the GUI as soon as I start.
The components you are creating makes a beautiful picture and makes logical sense in my mind to work together as a complete solution for the application layer.
