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
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
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
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!