EPPlus - Excel spreadsheets for .NET
EPPlus 6 is an improved version of the world´s most popular* spreadsheet library for .NET Framework/Core.
Get EPPlus 6 Now
EPPlus 6 is available on Nuget!
EPPlus 6.1.2 was published on the EPPlus Nuget feed on January 19, 2023
EPPlus 6 is here!
- Full functionality in all .NET environments, e.g. Linux, Blazor, Windows Nano server - EPPlus no longer needs System.Drawing.Common/libgdiplus on non-Windows platforms.
- Support for new image formats such as svg, ico and webp
- Html/Css export
- JSON export
- .NET 6 support.
- 30+ new functions supported in formula calculation
Version 6.1
- Improved security when signing VBA Macros, support for Agile and V3 signatures.
- New ToCollection method for exporting spreadsheet data directly to .NET classes.
- New methods for grouping, ungrouping, collapsing and expanding rows and columns.
- Supports .NET 7 from version 6.1.1.
Learn more
New pricelist from September 1, 2022
- USD prices unchanged
- Other currencies adjusted to current rate
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
Subscription by year
Subscription per year with support and upgrades | |
Starting at $379/license. Tiered pricing/volume discounts | |
Support via our portal |
Perpetual licenses
1 year or 2 years with support and upgrades | |
1 year starting at $599/license and $349 for renewal. Tiered pricing/volume discounts. Discounted packages starting at 10 developers | |
Support via our portal |
Enterprise license
Licensing adjusted to special requirements. | |
Get a quote | |
Priority support available |
We have partnered with global software distributor ComponentSource.
Developers
New license model, but code still fully available.
Why we have changed the license model
If you have used EPPlus under LGPL, here is why we have changed the license model.
Learn moreWe are a "Stödföretag" (supporting company) for the Swedish Red Cross 2022.