EPPlus 6 is available on Nuget!
EPPlus 6.2.4 was published on the EPPlus Nuget feed on May 15, 2023
Changelog
EPPlus 7 Preview
EPPlus 7 has a new calculation engine with improved performance and many new features.
- Dynamic array formulas
- Legacy array formulas
- Over 20 new functions supported
- Many other improvements
Learn more
New features in EPPlus 5/6
Features and improvements in the new version.
Worksheets/Ranges
|
Split worksheet into panes |
|
Easier access to Rows and Columns - Worksheet.Rows, Worksheet.Columns, Range.EntireRow and Range.EntireColumn |
|
New Fill functionality and improved Copy method on Ranges. |
|
Insert/Delete ranges in worksheets and rows/cols in tables |
Import/Export
|
Export html/css from worksheet ranges and tables New! - Check it out here! |
|
Export json data from worksheet ranges and tables New! - Check it out here! |
|
Support for exporting data from worksheets to files and DataTable |
|
Support for importing dynamic/ExpandoObject to worksheets and a new set of attributes extending the capabilities of the LoadFromCollection method. |
Tables/Pivot tables/Slicers
|
Pivot table- and table- slicers |
|
Custom table-, pivot table- and slicer styles |
|
Pivot table styling via pivot areas |
|
Extended support for Pivot tables - Filters, calculated columns, support for shared caches, auto sort and "Show Value As" on data fields |
Formula calculation
|
Improvements of the formula calculation engine and 181 new supported functions |
General improvements
|
Supports more image types than before - svg, ico and webp New! |
|
Removed dependency to System.Drawing.Common/GDI - works seamlessly in non-Windows environments New! |
|
Async methods for I/O operations |
|
Hundreds of fixed issues and minor improvements |
Miscellaneous new features
|
Support all Excel 2019 chart types with the new, modern styling - Check it out here! |
|
Threaded comments with support for mentions |
|
Themes, Filters, Ignore errors |
|
Support for form controls and grouping of drawings |
|
External links |
|
Enhanced sorting - Sort state, left-to-right and custom list sorting and auto sort on pivot tables |
Commercial licenses
Choose the licensing model that suits you best
Developers
New license model, but code still fully available.
EPPlus @ github
Our code repo, issue tracker and developer wiki.
EPPlus @ github
Developer resources
Here is where you find documentation, tutorials and more.
Learn more
Why we have changed the license model
If you have used EPPlus under LGPL, here is why we have changed the license model.
Learn more