TMS FlexCel Studio for .NET with NuGet v7.15.0.0
TMS FlexCel Studio for .NET with NuGet v7.15.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 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.15
New : You can now run reports on List like List
New : Support for functions TEXTBEFORE, TEXTAFTER, TEXTSPLIT, HSTACK, VSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND
New : Support for functions MAP, REDUCE, SCAN, MAKEARRAY, BYROW, and BYCOL
New : Support for functions FILTER, SORT, SORTBY, and UNIQUE
New : New SHEET VISIBLE tag that allows to change the visibility of a sheet in a report
New : FlexCelReport.AddConnection now supports adding IDbCommand directly
New : Ability to change the newline separator when exporting to CSV or Fixed-lenght text files
Improved : Support for Array formulas, UDFs, external names and Lambda names in Tokens
Improved : Improved behavior when inside Docker containers
Improved : Function "INDEX" is now array-enabled
Fixed : When third-party files had invalid modify/creation dates, FlexCel would refuse to open them. Now it will just ignore invalid dates and let those properties empty.
Fixed : There could be errors in some specific cases when copying sheets from one file to another which had linked formulas.
Fixed : The limit for custom formats in xls files was in 4000 when it really is 4050. We've updated FlexCel to allow 4050 custom formats when saving as xls.
Fixed : The functions SWITCH and IFS could fail is some border cases.
Fixed : The [TYPE](https://support.microsoft.com/en-us/office/type-function-45b4e688-4bc3-48b3-a105-ffa892995899) function didn't return 128 for lambda functions.
Fixed : Sometimes RenderObjects would not render the images. See https://support.tmssoftware.com/t/images-disappear-sometimes/18567/6
Fixed : Some files containing khmer characters (or other complex scripts) could raise an exception when exporting to pdf.
Fixed : Cells with diagonal borders, but borders style set to none could be rendered by FlexCel in some cases.
Fixed : Bubble charts could render bubbles of the wrong size if there were empty points in the chart data with bubble size different from 0.
New : You can now run reports on List like List
New : Support for functions TEXTBEFORE, TEXTAFTER, TEXTSPLIT, HSTACK, VSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND
New : Support for functions MAP, REDUCE, SCAN, MAKEARRAY, BYROW, and BYCOL
New : Support for functions FILTER, SORT, SORTBY, and UNIQUE
New : New SHEET VISIBLE tag that allows to change the visibility of a sheet in a report
New : FlexCelReport.AddConnection now supports adding IDbCommand directly
New : Ability to change the newline separator when exporting to CSV or Fixed-lenght text files
Improved : Support for Array formulas, UDFs, external names and Lambda names in Tokens
Improved : Improved behavior when inside Docker containers
Improved : Function "INDEX" is now array-enabled
Fixed : When third-party files had invalid modify/creation dates, FlexCel would refuse to open them. Now it will just ignore invalid dates and let those properties empty.
Fixed : There could be errors in some specific cases when copying sheets from one file to another which had linked formulas.
Fixed : The limit for custom formats in xls files was in 4000 when it really is 4050. We've updated FlexCel to allow 4050 custom formats when saving as xls.
Fixed : The functions SWITCH and IFS could fail is some border cases.
Fixed : The [TYPE](https://support.microsoft.com/en-us/office/type-function-45b4e688-4bc3-48b3-a105-ffa892995899) function didn't return 128 for lambda functions.
Fixed : Sometimes RenderObjects would not render the images. See https://support.tmssoftware.com/t/images-disappear-sometimes/18567/6
Fixed : Some files containing khmer characters (or other complex scripts) could raise an exception when exporting to pdf.
Fixed : Cells with diagonal borders, but borders style set to none could be rendered by FlexCel in some cases.
Fixed : Bubble charts could render bubbles of the wrong size if there were empty points in the chart data with bubble size different from 0.