Delphi

TMS FlexCel for VCL, FMX & Lazarus v7.20 Full Source

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

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.20

New : Support for creating your own cultures when rendering Excel files
New : Support for Delphi 12
New : Improved Lazarus support
Improved : Removed canvas.getMatrix calls in Android as they are deprecated
Improved : Now FlexCel will use its own Random implementation
Improved : New setting FlexCelConfig.LocalizedTEXTFunction allows you to fine tune how FlexCel recalculates the "=TEXT()" function
Improved : Improved Label rendering when drawing charts
Improved : FlexCel is more forgiving with too long data validation formulas
Improved : Better support for subnormal numbers
Fixed : When parsing some PNGs FlexCel could raise an arithmetic overflow.
Fixed : When drawing Error Bars in charts, if there was no line color assigned, FlexCel would not draw the lines instead of drawing them in Black.
Fixed : When autofitting rows FlexCel ignored empty columns formatted with big fonts.
Fixed : The XLOOKUP function would return "not found" when searching for a value bigger than any on the list and the match mode was "Exact match or next larger item", when there were empty entries in the list. This is the logical way to do it, it is how Google Sheets does it, and it is how Excel itself behaves in the other match modes. But for this match mode, Excel returns the first empty item in the list, not "not found". Now FlexCel mimics this behavior.
Fixed : The SINGLE function could return wrong results in very special cases.
Fixed : Some files could show the error: "Value was either too large or too small for an Int32" when opened.
Fixed : If the column names of a table had a format like "@_@" or similar, FlexCel would apply them and the column name would be wrong. Now the names are the same as in Excel. Some other improvements in handling of column names.
Fixed : FlexCel could fail to detect circular references in some corner cases, causing a Stack Overflow.

Additional Information