Description

Powerful, extensive & flexible component suite for native Excel report & file generation & manipulation for VCL & FireMonkey.

FlexCel for VCL / FireMonkey is a suite of Delphi components allowing to manipulate Excel files. It includes an extensive API allowing to natively read/write Excel files. If you need to read or create complex spreadsheets, on Windows or macOS on machines without Excel installed, Flexcel can do the job.

Support for cross platform use: Win32, Win64, macOS, iOS, Android and Linux
100% Native support for creating Excel .XLS, .XLSX, .XLSM file formats (Excel 97 - Excel 2019)
100% Native support for reading Excel 2 - Excel 2019 files
100% Native PDF report generation from .XLS/.XLSX files (PDF/A 1, 2 and 3 support)
100% Native support for previewing and printing .XLS/.XLSX files
Fully standards compliant HTML 5 file generation from .XLS/.XLSX files
Export .XLS & .XLSX files to SVG
Report Engine that allows to create complex reports using Excel as your report designer, so your final users can modify them. You can use images/comments/conditional formats/merged cells/pivot tables/charts and almost anything you can think of on those reports
Support for formula recalculation supporting over 300 Excel functions
ApiMate tool for automatically showing needed Delphi/C++ code for generating specific .XLS/.XLSX file cells with Flexcel
Templates can be embedded inside your exe. No additional files to distribute
Can write images/comments/conditional formats/merged cells/pivot tables/charts and almost the complete Excel feature set in native mode
Designed from start to make full use of modern Delphi features like records with methods or generics.
Also available as a fully managed .NET library
Fully documented. FlexCel has a documentation center with guides, tips, full reference for every method and more than 50 working examples to help you get started.

v7.24
New : Support for Delphi 12.3 and installing in the 64 bit IDE
New : Support Grouping objects
Improved : Improved rendering of conditional formats icons
Improved : Improved recovery mode
Improved : Gridlines colors are now exported to HTML
Improved : Faster rendering of files when there are thousands of hidden rows
Improved : Exporting gradient cell backgrounds to HTML
Improved : Exporting Conditional Format Icons and DataBars to HTML
Fixed : When recalculating a formula with =AVERAGEIF that had a a bad argument (for example a string where there should be a reference) FlexCel would throw a Invalid Cast exception. Now it returns #N/A! for the value of the formula.
Fixed : When inserting or deleting cell, pivot tables might not move.
Fixed : When exporting cells with "WrapText=false" to HTML, FlexCel would wrap the enters inside anyway.
Fixed : Right-align indented text wasn''t correctly exported to HTML.
Fixed : In special cases, charts copied with InsertAndCopy commands wouldn''t show in Excel online.
Fixed : If a group (but not the shapes inside it) was marked as "do not print" FlexCel would print it anyway. Now we behave as Excel, and only print/don''t print depending in the main shape of the group. You can''t disable individually printing shapes inside a group.
Fixed : FlexCel failed to open xls files with a missing OPT record.
Fixed : FlexCel could fail to open old xlsx files which had notes with non-breaking spaces.
Fixed : FlexCel could fail to export some files with invalid characters to HTML, due to issues in GDI+.
Fixed : Depending on the font, when exporting a cell to PDF which had an enter but no wrap text, FlexCel could draw an empty rectangle instead of completely ignoring the enter.
Fixed : A bidirectional report having a full column range could raise a "too many rows" exception in some cases where there were enough rows left.

Additional Information