Manage Spreadsheets in .NET 8 -EPPlus V7.0.3

Manage Spreadsheets in .NET 8

December 12, 2023

EPPlus V7.0.3 adds support for .NET 8, allowing developers to create, read and modify spreadsheets in the latest .NET release.

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The v7.0.3 release adds support for .NET 8. This enables developers to easily create and manage spreadsheets while working with the latest iteration of Microsoft's .NET ecosystem.

EPPlus v7.0.3

Released: Dec 5, 2023

Updates in v7.0.3

Features

• Added support for Microsoft .NET 8.
• Added Alignment and Protection properties to ExcelDxfStyle - Affects Table and Pivot Table styling.
• Improved handling of negation of ranges in formula calculation.
• Added AlwaysAllowNull property to ToDataTableOptions parameter of the ExcelRangeBase.ToDataTable function.

Fixes

• ExcelValueFilterColumn.Filters. Blank property now hides rows even if it contains no other filters.
• Resolved issue where ExcelValueFilterCollection.Add("") or adding null on ExcelFilterValueItem generated corrupt worksheet. The Blank property is now set to true instead.
• Hyperlinks were not correctly encoded if Unicode characters was used.
• External references in the lookup range did not work in the VLOOKUP & HLOOKUP functions.
• Copying worksheets with pivot tables caused a corrupt workbook in some cases.
• Insert/Deleting in ranges sometimes affected addresses referencing other worksheets.
• The ExcelRangeBase.Text property sometimes returned a formatted value with both - and () for negative values on some cultures.