Component TMS FlexCel

[FireWind]

TMS FlexCel
Powerful, extensive & flexible component suite for native Excel report & file generation & manipulation

Спойлер: Features

• 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 Для просмотра ссылки Войди или Зарегистрируйся
• 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 Для просмотра ссылки Войди или Зарегистрируйся
• Fully documented. FlexCel has a Для просмотра ссылки Войди или Зарегистрируйся with guides, tips, full reference for every method and more than 50 working examples to help you get started.

Copyright © Для просмотра ссылки Войди или Зарегистрируйся

 

[FireWind]

TMS FlexCel 7.1 for Delphi XE-10.3.Rio Full Source (Retail)

Спойлер: History

Version: 7.1

• Improved : Updated to the latest version of Skia for Linux
• Improved : The HTML engine can now parse tags
• Improved : Support for calculating BAHTTEXT function
• Improved : Reports can now use nested properties in Aggregates, Filters, Sort and Master-details relationships
• Improved : Removed overload method TExcelFile.GetImage(Integer, string, TXlsImgType, TStream)
• Improved : Now you can use report expressions that call themselves recursively, as long as the recursion converges
• Improved : Now for reports you can set semi-absolute references in the config sheet
• Improved : Improved recalculation speed and decreased memory usage
• Improved : Improved compatibility with invalid xlsx files
• Improved : Improved chart rendering
• Improved : Android64 Support
• Fixed : FlexCel would nor correctly read or write left and right cell borders in strict xlsx files.
• Fixed : FlexCel was failing to render images which had an image filled background.
• Fixed : FlexCel might not preserve comment backgrounds in xlsx files if the background was an image or texture.
• Fixed : FlexCel could fail to open some files which didn't completely implement the xlsx spec but which Excel could open.

Спойлер: Link

 

[FireWind]

TMS FlexCel 7.1 for Delphi 10.4.1 Sydney Full Source

Спойлер: History

Version: 7.1

• Improved : Updated to the latest version of Skia for Linux
• Improved : The HTML engine can now parse tags
• Improved : Support for calculating BAHTTEXT function
• Improved : Reports can now use nested properties in Aggregates, Filters, Sort and Master-details relationships
• Improved : Removed overload method TExcelFile.GetImage(Integer, string, TXlsImgType, TStream)
• Improved : Now you can use report expressions that call themselves recursively, as long as the recursion converges
• Improved : Now for reports you can set semi-absolute references in the config sheet
• Improved : Improved recalculation speed and decreased memory usage
• Improved : Improved compatibility with invalid xlsx files
• Improved : Improved chart rendering
• Improved : Android64 Support
• Fixed : FlexCel would nor correctly read or write left and right cell borders in strict xlsx files.
• Fixed : FlexCel was failing to render images which had an image filled background.
• Fixed : FlexCel might not preserve comment backgrounds in xlsx files if the background was an image or texture.
• Fixed : FlexCel could fail to open some files which didn't completely implement the xlsx spec but which Excel could open.

Спойлер: Link

password: dumpz.ws

 

[FireWind]

TMS FlexCel v7.8 for Delphi XE-10.4 Sydney [full source]

Спойлер: History

v7.8​

• New : Support for reading fonts from the disk even if the graphics library returns that information
• Improved : Improved compatibility with invalid xls files

v7.7​

• New : When copying a sheet to a different file, ImageCount in the target file would return 0 even if there were images.
• New : Improved support for camera objects. A new property [MaxNestedCameraObjects]//@api/FlexCel.Core/TFlxConsts/MaxNestedCameraObjects.html) allows to specify how many times a camera object can recursively draw itself.
• New : FlexCel wouldn't allow some unicode characters in 3d formulas, while Excel would allow them.
• New : FlexCel could not read some files with deleted what-if tables.
• Improved : Improved handling of unknown parts inside xlsx files and improved Google sheets compatibility

v7.6.4​

• New : New syntax for ALIAS DataSets
• New : New "COUNT" parameter in <#Aggregate> tag
• Fixed : When inserting cell ranges with multiple rows used as data by pivot tables, the pivot table might not adapt correctly.
• Fixed : When exporting to HTML both headers and footers would be ignored if you specified THidePrintObjects.Header, and THidePrintObjects.Footer was ignored. Now footers will work with THidePrintObjects.Footer and THidePrintObjects.Header will only hide the headers.
• Fixed : Sometimes when copying only format from cells, and the cells had only a column or row format, the format wouldn't be copied.
• Fixed : Some invalid third party xls files could fail to load.
• Fixed : Now nested <#aggregate> and <#list> tags will be put in master-detail if they are related.
• Fixed : Fixed issues with <#evaluate> tag when it evaluates recursively

v7.6.2​

• Fixed : When adding a chart to a file via the API and immediately rendering it to PDF without saving it, the chart might not be rendered in the PDF file.
• Fixed : Previously the last row in "X" Bands in reports was deleted before the detail bands were inserted. This could cause unwanted behavior if the details shared the same rows as the master. Now last rows in X Bands will be removed after the details are inserted.
• Fixed : DbValue could raise Exceptions in some cases.
• Fixed : A fixed band inside a master-detail bidirectional report would behave as non fixed.

v7.6.1​

• New : Support for Rad Studio 10.4 Sydney
• Improved : Improved conversion from strings to numbers
• Fixed : Deeply nested array formulas could return N/A results in some corner cases

v7.6​

• New : Support for rendering logarithmic charts
• New : Support for Rad Studio 10.4 Beta
• Improved : When rendering pages to PDF and PNG, if an image or chart goes over the columns or rows in a page, now it won't overflow
• Improved : Now FlexCel won't throw an Exception if a Font folder in the PDF FontFolder path doesn't exist
• Improved : Now FlexCel will search in c:\Windows\Fonts and %localappdata%\Microsoft\Windows\Fonts for fonts when exporting to PDF
• Improved : Improved handling of chart gaps when there are null values
• Fixed : Xlsm files containing macros and with sheet names starting with a number and bigger than 24 characters, could generate invalid files when saved in FlexCel.
• Fixed : When manually installing FlexCel in Delphi XE, Delphi XE would raise an exception. Note that this is a fix only for manual installation: automatic installation worked fine.
• Fixed : Sometimes when calling RenderObjects the border of a chart would not be exported to PDF or PNG.
• Fixed : Now FlexCel will validate when manually setting a sheet codename, that the name is ASCII and starts with a letter.
• Fixed : Now FlexCel will draw a maximum of 10000 ticks per axis in charts, to avoid taking too long drawing too many ticks that aren't visible anyway.
• Fixed : Manually positioned labels in stacked bar charts were a little offset from their manual position.
• Fixed : Leader lines in stacked bar charts were wrong when the axis was reversed
• Fixed : FlexCel would consider a protected range title containing a "?" invalid. This would prevent it from loading files that used "?" in protected ranges.
• Fixed : Bidirectional reports could fail to delete rows or columns in complex reports.

v7.5.1​

• Fixed : With some combinations of Delphi versions and platforms, you could get Access Violations when opening files in FlexCel 7.5. This was caused by a bug in the way Delphi handles method inlining, and it didn't happen in previous FlexCel versions. **If you installed FlexCel 7.5, please update.**

v7.5​

• New : Support for importing bullet lists when importing html
• New : Support for calculating the upcoming XLookup, XMatch, RandArray and Sequence functions
• New : Support for adding charts to a sheet with the API (xlsx files only)
• New : Preserving and adapting single cell mappings in XML Maps in xlsx files
• New : Now SetSeries and AddSeries, DeleteSeries work also in xlsx charts
• New : New set method in the properties PlotArea, Background in ExcelChart
• New : New methods SetTitle, SetOptions, SetChartLegend, SubchartCount, GetSeriesInSubchart, SetSeriesInSubchart and AddSubchart in ExcelChart
• Improved : Improved compatibility with invalid third party files
• Improved : Better chart rendering when there are date axis
• Fixed : When rendering charts you could get an index out of bounds in some corner cases.
• Fixed : FlexCel will ignore invalid themes when reading xls files
• Fixed : FlexCel wasn't calculating conditional formats if the formulas defining the conditions were array formulas.
• Fixed : FlexCel could fail to process some files where a shape had an ending coordinate smaller than the starting coordinate.

v7.1.1​

• New : New __ALIAS postfix in named ranges allows multiple ranges to the same database
• Fixed : When using a not standard row height for the whole sheet, FlexCel would create new rows to have automatic height, instead of having the standard row height for the sheet. This could confuse Excel.
• Fixed : Sometimes in Android 32 or 64 bits you could get a BUS (10) error.
• Fixed : In some corner cases charts saved by FlexCel inside xlsx files would fail to load.
• Fixed : FlexCel will now check that font sizes saved are between 1 and 409 points. Before it would let you save any font size, and invalid font sizes would crash Excel when opening the file.
• Fixed : Effects for an image in the background of an image could be incorrectly saved. In some cases, this could cause Excel to crash.

Спойлер: Link

password: dumpz.ws

 

[Vi_t]

почему при установке у меня ругается ,что уже тот же самый набор в AdvStringGrid Import and Export Filters?
Они перенесли эти копроненты вдругую библиотеку?

 

[FireWind]

почему при установке у меня ругается ,что уже тот же самый набор в AdvStringGrid Import and Export Filters?
Они перенесли эти копроненты вдругую библиотеку?

Библиотеки TMS тесно переплетены между собой. AdvStringGrid имеет экспорт в Excel, поэтому в нем есть урезанная версия FlexCel

 

[Vi_t]

Просто старую отключил библиотеку и подключил эту.
Ситуация напомнила TeeChart - одно имя модуля и разные реализации.
Спасибо

 

[FireWind]

TMS FlexCel v7.11 for Delphi & C++Builder XE-11 (September 9, 2021)

Спойлер: History

v7.11​

• New : You can now read and write the links of a camera object
• New : Support for RAD Studio 11
• New : New overloads of methods for getting image information that take objectIndexes instead of imageIndexes
• New : New methods to convert between imageindexes and objectindexes with support for grouped shapes
• Improved : Improved loading of Excel 3, 4 and 95 files

v7.10​

• New : Support for recalculation of function NUMBERVALUE
• New : Support for SVG images embedded in xlsx files
• New : Now when exporting to HTML and SVG, the SVG images stored inside the file will be embedded as SVG
• New : Includes in reports can now be FIXED
• New : Full Window management via API
• New : Ability to set shape effects like glow or shadow with the API
• New : Ability to link shape text to cells via the API
• New : Ability to add chart sheets with the API
• Improved : Improved support for Tiff and Gif images
• Improved : Improved recalculation speed
• Improved : Improved handling of linked text in autoshapes
• Improved : Improved drawing of shape shadows for xlsx files
• Improved : Improved drawing of log-chart gridlines
• Improved : Improved HTML5 exporting
• Improved : Comments added with the API won't include a shadow
• Improved : Better handling of third-party xls files
• Fixed : When using <#database.#rowcount> in expressions outside the sheet, you could get an exception.
• Fixed : When renaming tables FlexCel wasn't renaming references in column formulas
• Fixed : Text to autoshapes added with the API would always be left-aligned.
• Fixed : Sometimes FlexCel could fail to parse formulas with hard-coded arrays which had strings inside.
• Fixed : Reports using TDataSets in master-detail could get the wrong results if both master and detail had the same underlying dataset.
• Fixed : FlexCel would not export to pdf 3rd-party files which had unreadable file properties.
• Fixed : FlexCel could throw an exception when inserting columns in xls files with invalid external references
• Fixed : FlexCel could throw an Exception when manually adding an autoshape to a chart that was created via the API.
• Fixed : FlexCel could report the BOM when reading custom XML parts inside xlsx files. Now the BOM is stripped out as it should.
• Fixed : FlexCel could crash when rendering chart labels with "Value from cells" if the range existed but was null.
• Fixed : Excel could crash with files including charts with Soft edges effect.
• Fixed : Conditional formats with iconsets where some values of the iconset were "No icon" could be saved wrong.
• Fixed : Comments could lose or gain a shadow when converting from xls to xlsx or xlsx-strict. Also colors in the comments could be wrong in border cases.
• Fixed : Better compatibility with files generated by FastReports. Excel ignores border style 0 and fill styles 0 and 1, and now FlexCel ignores those too.
• Fixed : ApiMate would not suggest how to add a shape without borders
• Fixed : Accessing some Conditional formats with inner borders could cause an Exception.

Спойлер: Link

password: dumpz.ws