Bytescout.Spreadsheet 4.1.0.1944

ByteScout Spreadsheet SDK for .NET, ASP.NET, ActiveX/COM - create and modify Excel files

Install-Package Bytescout.Spreadsheet -Version 4.1.0.1944

dotnet add package Bytescout.Spreadsheet --version 4.1.0.1944

<PackageReference Include="Bytescout.Spreadsheet" Version="4.1.0.1944" />

paket add Bytescout.Spreadsheet --version 4.1.0.1944

#r "nuget: Bytescout.Spreadsheet, 4.1.0.1944"

// Install Bytescout.Spreadsheet as a Cake Addin
#addin nuget:?package=Bytescout.Spreadsheet&version=4.1.0.1944

// Install Bytescout.Spreadsheet as a Cake Tool
#tool nuget:?package=Bytescout.Spreadsheet&version=4.1.0.1944

Release Notes

ByteScout Spreadsheet SDK for .NET, ASP.NET, ActiveX/COM
ByteScout, Inc. (c) 2006-2021.

- Does not require Excel or Office installed;
- Formula calculation support (Excel style formulas);
- Reads XLS, XLSX, ODS (Open Office Calc), CSV formats;
- Writes XLS, XLSX, CSV, TXT, XML, JSON, HTML, PDF formats;
- Imports from and exports to JSON format;
- Supports cell formating, rich text, charts, images, borders, etc.;
- Supports legacy languages like Visual Basic 6, VBScript, JScript, ASP through ActiveX/COM interface;
- Command line utility is included for conversion of spreadsheet files from command line or .BAT files;
- And more...

History of changes:

4.1.0.1943 (February 8, 2021)
+ WinFormsControl: Added support for touch gestures: panning and inertial scrolling.
= Improved CSV export.
= Improved parsing of formulas.
= Improved support for custom cell formats.
= Improved worksheet splitting and freezing.
- Added missing "COUNTIFS" formula.
- PDF export: fixed crash on empty spreadsheet.
- Fixed loading of SpreadsheetML (XML Spreadsheet) documents from stream.
= .NET Core build is now Linux-compatible.
= Other minor fixes and improvements.

4.0.0.1910 (October 26, 2020)
+ Added support for SUBSTITUTE and COUNTBLANK functions.
- Fixed parsing and calculation of the unary plus and minus operators.
- Fixed freezing of rows and columns.
- Fixed saving of named ranges in XLS and XLSX formats.
- Fixed editing of protected worksheets.
= Improved parsing of OpenXML spreadsheets.
= Added informational properties 'Cell.ColIndex' and 'Cell.RowIndex'.
- Fixed 'Row.NumberFormat' and 'Column.NumberFormat' properties.
- Fixed 'Cell.FontColorIndex' property.
= Improved ODF spreadsheet detection when reading from stream.
- Fixed tread-safety issue.
= Other minor fixes and improvements.
= Improved .NET Core compatibility.
= Other minor fixes and improvements.

3.9.0.1872 (July 1, 2020)
= Improved the parsing of formulas.
= Improved handling of protected worksheets.
= 'Workbook.PictureList' now contains collection of all images in the spreadsheet.
= Improved automatic page size when exporting to PDF.
= Other minor fixes and improvements.

3.8.0.1843 (March 19, 2020)
- Conditional formatting was lost when saving.
- Worksheet auto-calculation was not working for some formulas.
= Improved support for worksheet protection.
= Improved .NET Core compatibility.
= Other minor fixes and improvements.

3.7.0.1832 (February 11, 2020)
= Improved export to PDF format.
= Other minor fixes and improvements.

3.6.0.1814 (December 4, 2019)
+ Added Worksheet reference to `CustomFunctionsCallback` delegate providing access to worksheet that contains custom function.
- Fixed calculation of custom functions when opening a document.
= Other minor fixes and improvements.

3.5.0.1807 (November 1, 2019)
+ XLSX: Added support for Table objects and references.
- Fixed parsing of formulas with omitted arguments.
= Improved parsing of complex headers and footers.
= Other minor fixes and improvements.

3.4.4.1790 (October 1, 2019)
= Improved parsing of Excel functions.
= Minor fixes and improvements.

3.4.3.1790 (September 2, 2019)
= Minor fixes and improvements.

3.4.2.1783 (August 6, 2019)
= Minor fixes and improvements.

3.4.1.1781 (July 1, 2019)
= Accelerated parsing of spreadsheets that contain very large named ranges.
= Minor fixes and improvements.

3.4.0.1778 (May 18, 2019)
+ Added password parameter to 'SaveAsPDF()' method.
= Improved export to JSON.
+ Added option to disable automatic calculation.
+ Added new set of properties 'Workbook.WorkbookView' containing visual options for Excel tabs and scroll bars.
= Other minor fixes and improvements.
- Fixed exception when running in Medium Trust web application.

...

Dependencies

• .NETCoreApp 2.0

  • Microsoft.Windows.Compatibility (>= 2.0.0)

Used By

Version History