TMS FlexCel for VCL and FMX
Powerful, extensive & flexible component suite for native Excel report & file generation & manipulation for VCL & FireMonkey
Reading an XLSX file with Flexcel with the “Reading Files” example, showing contents of a cell as HTML:
Getting started demo running on Windows 7
Excel .XLSX file generated from a FireMonkey app running on macOS Lion with Excel 2011
ApiMate tool showing needed Delphi code to generate cells in an .XLSX file
Free interface between TMS Grids and TMS Flexcel to provide import/export capabilities to .XLS & .XLSX, .PDF formats.
Thanks for an excellent product. I did have some issues Friday but these were expertly solved by Adrian Gallero over the weekend. I cannot recommend you products and service high enough. Thanks and kind regards
Kevin Clegg / Soft Options, via email
It’s now very easy to build a report with the new Flexcel + Aurelius integration. It was so easy that I really thought I was doing something wrong. I will never go back to a report generator, Flexcel is way cooler and easier for reports
Eduardo Elias / Yashar software, via email
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.
Single Developer license, Site license