EPPlus 6.1.0

Adds new methods to group, ungroup, collapse and expand rows and columns.
November 3, 2022
New Version

Features

  • Added support for new types of VBA signing:
    • Agile VBA Signing.
    • V3 VBA Signing.
  • Change hash algorithm on a VBA signature. This supports MD5, SHA1, SHA256, SHA384 and SHA512.
  • Added ExcelRange.ToCollection method to export data from a spreadsheet into an IEnumerable<T> where T is a class.
  • Added new methods to group, ungroup, collapse and expand rows and columns:
    • Group method.
    • Ungroup method.
    • CollapseChildren method.
    • ExpandChildren method.
    • SetVisibleOutlineLevel method.
  • Added new overloads of Drawings.AddPicture which read the signature of the image from a stream to identify the type of image:
    • AddPicture(string, Stream).
    • AddPicture(string, Stream, Uri).
  • These overloads have been deprecated:
    • AddPicture(string, Stream, ePictureType).
    • AddPicture(string, Stream, ePictureType, Uri).
  • Added the ability to preserve 'Table' formula properties (Created via the What-If Analysis-Data Table).
EPPlus

EPPlus

Create, read and modify Office Open XML spreadsheets.

Got a Question?

Live Chat with our EPPlus Software licensing specialists now.