EPPlus - Excel spreadsheets for .NET
EPPlus 7 is an improved version of the highly popular* spreadsheet library for .NET Framework/Core.
Get EPPlus 7 Now
EPPlus 7 is available on Nuget!
EPPlus 7.4.2 was published on the EPPlus Nuget feed on October 28, 2024
Our customers
We have thousands of commercial customers - from Fortune 500 to start ups. The logotypes below are published with the customers written consent.EPPlus 7 is here!
EPPlus 7 has a new calculation engine with improved performance and many new features.
- Dynamic array formulas
- Legacy array formulas
- 100+ new functions supported
- Many other improvements
Conditional Formatting improvements
- Improved performance, xml is now read and written on load and save.
- Cross worksheet formula support.
- Extended styling options for color scales, data bars and icon sets.
Version 7.1
- Improvements on HTML-export, the LoadFromCollection method and handling of rich text.
Version 7.2
- Pivot table calculation, including support for the GETPIVOTDATA function in calculations.
- Full support for conditional formats in HTML-export, including icon-sets and databars.
- Added support for copying drawings.
- Support for transposing ranges in import/export functions and when copying ranges.
- Added support for importing and exporting fixed width text files.
- New functions supported in formula calculations: GETPIVOTDATA, MMULT, MINVERS, MDETERM, MUNIT, TEXTSPLIT, TEXTAFTER, TEXTBEFORE, LET
Version 7.3
- Support for Precision As Displayed
- New functions supported in formula calculations: LINEST, LOGEST, GROWTH, TREND, DPRODUCT, DSTDEV, DSTDEVP
Learn more
Previous version - EPPlus 6
- 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
Download our pricelists
- Available in 8 different currencies
- New price list from January 2, 2024
New features in EPPlus 5/6/7
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 - Check it out here! | |
Export json data from worksheet ranges and tables - 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
Dynamic arrayformulas, pivot calculations, 450+ supported functions, better performance and many other improvements New! |
General improvements
Supports more image types than before - svg, ico and webp | |
Removed dependency to System.Drawing.Common/GDI - works seamlessly in non-Windows environments | |
Async methods for I/O operations | |
Conditional formatting - improved support for databars, custom iconsets and cross worksheet references. New! | |
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 $449/license. Tiered pricing/volume discounts | |
Support via our portal |
Perpetual licenses
1 year or 2 years with support and upgrades | |
1 year starting at $719/license and $419 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