Released: Mar 28, 2025

v8.0.1 中的更新

特性

• EPPlus version 8 and later commercial licenses now require a license key to be specified before using EPPlus. This must be set both in the development and in the runtime environments.
• Support for OLE objects (Linked or Embedded files).
• Support for digital signing workbooks and signature lines.
• In-cell pictures / support for the IMAGE function.
• Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
• Autofit columns optimization.
• The Range Copy method now supports...

Released: Mar 17, 2025

v7.7.0 中的更新

修補程式

• Reverted System.* and Microsoft.* references to 8.0.x for all target frameworks except .NET 9.
• Fixed issue where LoadFromArray and LoadFromDataTable of the ExcelRangeBase class did not clear existing formulas before populating the range.
• Fixed a rare issue when copying images between named ranges.
• Fixed issue when sorting a range with formulas, the formulas addresses were sometimes updated incorrectly.
• Fixed issue where GetAsByteArrayAsync could not be called more than once.

Released: Mar 4, 2025

v7.6.1 中的更新

修補程式

• Fixed issue where pivot caches with error values in the source data were not handled correctly.
• Fixed problem where timespan was not correctly converted in the GetValue function.
• Fixed issue where the ExcelWorksheet.DimensionByValue property sometimes threw an unhandled exception.
• Fixed error where the FIND function did not handle empty cells correctly in all cases.
• Fixed issue where range sorting did not handle threaded comments.
• Fixed issue where Table.AddRows incorrectly shifted the...

Released: Feb 6, 2025

v7.6.0 中的更新

特性

• Added Microsoft .NET 9 as a target framework.
• Removed out of support frameworks - .NET 6 and .NET 7.

修補程式

• Fixed an issue handling formulas when sorting a range.
• Insert row in table caused corrupt workbook.
• A workbook could lose styles if the ExcelPackage.FullPrecision property was set.
• When copying a worksheet, drawings would be resized after inserting rows. This was caused by drawings being copied before styles and therefore drawings would not be aware of any styles.
• Set Active Tab did not...

Released: Jan 16, 2025

v7.5.3 中的更新

特性

• Improved COUNTIF performance, if full column addresses was used.
• Added null as valid GetByValue for pivot table field items.
• Added support for [h]:mm number format.
• Improved sorting for pivot table slicer cache.
• Added Drawings.AddTextBox for easier creation of textboxes.

修補程式

• If having a workbook with no reference to a font in the styles.xml, caused an corrupt workbook.
• ZipEntry's containing the zip data descriptor header could result in a BadReadException.
• Fixed comment indices when sorting...

Released: Dec 9, 2024

v7.5.2 中的更新

修補程式

• Fixed issue where pivot tables with blanks could cause the pivot table to become corrupt.
• Fixed error handling in the TEXTJOIN, TEXTSPLIT and CONCAT functions.
• Fixed issue where an exception was thrown when trying to delete the last column in a worksheet.
• Fixed issue where ExcelColor.LookupColor() returned an unexpected color code for empty colors. LookupColor() now returns an empty string for empty colors.
• Fixed issue where DimensionByValue would throw an System.ArgumentException: 'Column...

Released: Nov 21, 2024

v7.5.1 中的更新

修補程式

• Style set on column/row level did not save on cells with a value and styleId is 0.
• Fix for inserting rows after array formulas when referring to worksheets with '#' as part of the worksheet name.
• Pivottable Field.Names on a field with rich text now returns the text content instead of 'OfficeOpenXml.Style.ExcelRichTextCollection' string.
• Fixed .ToDataTable not reading rich text correctly in rare cases.
• ExcelPicture.Image.SetImage(" can now correctly be set to a .svg even if the original...

Released: Nov 15, 2024

v7.5.0 中的更新

特性

• Added signatures to the EPPlus.dll's and the EPPlus NuGet package.
• Added new RepeatItemLabels and InsertBlankRow properties to ExcelPivotTableField.
• Added AllowDuplicateColumnNames to ToDataTableOptions. This allows the exported range in the ToDataTable method to have duplicate column names.

修補程式

• A NullReferenceException was sometimes thrown when saving line charts with droplines.
• Fix for cells with null values and no style id getting incorrect styling.
• Fixed an issue where two VLOOKUPs on...

Released: Oct 28, 2024

v7.4.2 中的更新

特性

• Added support for the array attribute on table column formulas:
  • Added new property 'ExcelTableColumn.IsCalculatedFormulaArray'.
  • EPPlus automatically updates the IsCalculatedFormulaArray if a table formula is identified as an array formula in the calculation.
• You can now add mappings for error values as a string in the ToDataTableOptions.

修補程式

• Rich text strings in the shared strings XML did not support both text and RichText elements in the same item.
• The dynamic array formula flag was not set...

Released: Oct 11, 2024

v7.4.1 中的更新

修補程式

• Updated for vulnerability in System.Text.Json 8.0.4 - Microsoft.Extensions.Configuration.Json 8.0.0 -> 8.0.1.
• Having more than three minus symbols before an error value adds an extra minus to a formula when inserting rows or columns.