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.1 was published on the EPPlus Nuget feed on November 21, 2022
EPPlus 6 is here!
- Full functionality in all .NET environments, e.g. Linux, Blazor, Windows Nano server - EPPlus is no longer dependent on System.Drawing.Common/libgdiplus
- 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 more |
 |
We are a "Stödföretag" (supporting company) for the Swedish Red Cross 2022.