TMS FlexCel for VCL, FMX & Lazarus v7.22 Full Source
TMS FlexCel for VCL, FMX & Lazarus v7.22 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 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.22
New : Suspended Lazarus support
Improved : Vastly improved memory usage in TFlexCelPreviewer when previewing thousands of sheets at the same time
Improved : FlexCel will now choose the best font to export to PDF if a font is repeated multiple times in the Fonts folder
Fixed : When a sheet had a print area with an invalid sheet, like #REF!A1:A2, FlexCel would assume the print area was A1:A2 anyway in the current sheet. Now the print area is correctly ignored.
Fixed : The =COLUMN function could return wrong values when used in an array formula.
Fixed : Labels in a Legend when the label range had multiple rows and columns didn''t show the same as Excel. See https://support.tmssoftware.com/t/pie-chart-legend/23077
Fixed : Improved compatibility with invalid third party files.
Fixed : FlexCel is now more strict in detecting fonts whose license doesn''t allow embedding when exporting to PDF. You can set FlexCel to ignore licensing restrictions by setting the [UnlicensedFontAction](://@api/FlexCel.Render/TFlexCelPdfExport/UnlicensedFontAction.html#syntax) property in the FlexCelPdfExport object.
Fixed : FlexCel could fail to save a file with multiple views of the same file when you added a new sheet to it.
New : Suspended Lazarus support
Improved : Vastly improved memory usage in TFlexCelPreviewer when previewing thousands of sheets at the same time
Improved : FlexCel will now choose the best font to export to PDF if a font is repeated multiple times in the Fonts folder
Fixed : When a sheet had a print area with an invalid sheet, like #REF!A1:A2, FlexCel would assume the print area was A1:A2 anyway in the current sheet. Now the print area is correctly ignored.
Fixed : The =COLUMN function could return wrong values when used in an array formula.
Fixed : Labels in a Legend when the label range had multiple rows and columns didn''t show the same as Excel. See https://support.tmssoftware.com/t/pie-chart-legend/23077
Fixed : Improved compatibility with invalid third party files.
Fixed : FlexCel is now more strict in detecting fonts whose license doesn''t allow embedding when exporting to PDF. You can set FlexCel to ignore licensing restrictions by setting the [UnlicensedFontAction](://@api/FlexCel.Render/TFlexCelPdfExport/UnlicensedFontAction.html#syntax) property in the FlexCelPdfExport object.
Fixed : FlexCel could fail to save a file with multiple views of the same file when you added a new sheet to it.