Dotnet

TMS FlexCel Studio for .NET with NuGet v7.17.0.0

100% managed code Excel file manipulation engine & Excel & PDF report generation for .NET, Xamarin.iOS, Xamarin.Android, Xamarin.Mac.

Feature overview
Create applications, webservices and mobile device apps that...

Description

100% managed code Excel file manipulation engine & Excel & PDF report generation for .NET, Xamarin.iOS, Xamarin.Android, Xamarin.Mac.

Feature overview
Create applications, webservices and mobile device apps that read and write Excel files on the fly and fast with FlexCel Studio for .NET
Native .NET components (no additional OLE/dlls required) allowing to read, create and modify native Excel .XLS and .XLSX files without needing to have Excel installed
Supported Excel 2 to 2021 file formats
Runs on .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, .NET 4.5, .NET 4.6, .NET 4.7, .NET 5, .NET 6, .NET Core, Windows Universal Apps, Windows Phone 8.1, Windows Store 8.1, Xamarin.iOS, Xamarin.Android, Xamarin.Mac and Mono
Exceptionally fast and solid hand tuned .XLS & .XLSX engine capable of generating thousands files per minute
Able to modify .XLS and .XLSX files and keep almost everything existing on the original file, from macros to activex objects
Support for formula recalculation supporting over 300 Excel functions
Ability to read and write encrypted .XLS and .XLSX files, including Office 2007, 2010 and 2013 encryption
Completely written in C# 100% managed code, with NO interop and NO p/invokes
Extensive API is available with which you can programmatically write and read files, with formatting info, images comments, etc.
Native PDF file export / report generation (PDF/A 1, 2 and 3 support)
Export to HTML in HTML 5 strict or XTHML 1.1 and fully standards compliant
Natively print and preview Excel files
Export 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
Full feature overview
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.17

New : Removed support for .NET Core 3.1 and 5.0
New : Optimized support for .NET 7
New : Now FlexCel preserves digital signatures in macros
New : New property DeleteEmptyBandsFixed in FlexCelReport controls what to do with empty fixed bands
New : Improved API for defining columns in tables
Improved : SkiaSharp updated to 2.88.3
Fixed : When recreating a table by calling AddTable and SetTable, the cell references could become invalid
Fixed : The functions IFERROR, ISERROR and ISERR could sometimes return the error instead of the result of the function.
Fixed : The functions COUNTIF, SUMIF and similar could behave wrong in some cases where you used wildcards. See https://support.tmssoftware.co... : The function [TRIM](https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9) in Excel removes double spaces in the middle of a text, while FlexCel's implementation would remove only spaces at the beginning at end. Also Excel's TRIM only removes spaces (character 32) and not other whitespace like tabs. FlexCel's implementation now does the same.
Fixed : The function =NUMBERVALUE() could throw an Exception in some border cases

Additional Information