EPPlus 8
New major version (Beta) was released February 13, 2025
EPPlus 8 introduces the following new features.
Digital signing of workbooks
The Digital Signature feature in spreadsheet programs lets users verify a document's integrity and origin. By adding a digital signature, you ensure the content hasn't been altered since signing. This is useful for authenticating important documents. A digital certificate is required, serving as a unique identifier. Once applied, the signature assures others that the document is legitimate and secure.
From version 8 you can sign workbooks/add signature lines with EPPlus. See our Github wiki for more details:
OLE Objects
OLE (Object Linking and Embedding) allows you to embed various types of files, such as Word documents, PowerPoint slides, and images, directly into your workbook. This feature ensures that the embedded objects become part of the workbook itself, making it easy to create comprehensive and interactive reports. Unlike linking, embedding means the objects are stored within the workbook, ensuring they remain accessible even if the source files are moved or deleted.
In-Cell Pictures
In-Cell Pictures in Excel is a feature that allows you to insert images directly into cells, enhancing data visualization. This feature is particularly useful for creating more engaging and informative spreadsheets, such as including product images in an inventory list or charts.
The IMAGE function supports this by enabling you to add pictures from a URL. It supports various image formats and adjusts the size of the images to fit the cells, making it easy to integrate visuals seamlessly into your data.
Sensitivity Label API
Sensitivity labels in Microsoft Purview help protect and manage sensitive information by classifying and labeling data based on its sensitivity level. These labels can enforce encryption, restrict access, and apply watermarks, ensuring that sensitive data is handled appropriately and securely across your organization.
EPPlus 8 introduces new interfaces to work with sensitivity labels via the Microsoft Information Protection (MIP) SDK. These interfaces allow developers to programmatically apply and manage sensitivity labels in Excel files, enhancing data protection and compliance within their applications.
User-Requested Features in EPPlus 8
EPPlus 8 has introduced several new features based on feedback from our user community. These enhancements aim to improve functionality and user experience, ensuring that our software continues to meet the evolving needs of our dedicated users.
Feature | More details |
---|---|
New property DataRows in ExcelTables for easier access and manipulation of the table's data. | |
AutofitColumns performance improvements | EPPlus wiki: AutofitColumns |
EPPlus now rounds decimal numbers more closely to Excel's precision. | |
Range Copy now support fills (repeated fills of the source range) | |
Insert range now returns the inserted range. | EPPlus wiki: Insert ranges |
Shape adjustments points can now be changed | EPPlus wiki: Shapes |
Default theme of workbooks updated to the latest Excel theme 202300. |
License keys
EPPlus 8 introduces license keys for commercial licenses and a new interface for providing license information. See this page for Commercial Use and this page for Noncommercial/Personal Use
Q & A
EPPlus 8.0.0 Beta was released on February 14, 2025.
Yes, if your license still is active/valid. You will find your license key in the My Licenses section here on our website.