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 has been downloaded over 100 million times. It is used by thousands of companies all over the world to manage their spreadsheet data.
Nuget downloads

EPPlus 7 is available on Nuget!

EPPlus 7.5.1 was published on the EPPlus Nuget feed on November 21, 2024

Changelog


Our customers
We have thousands of commercial customers - from Fortune 500 to start ups. The logotypes below are published with the customers written consent.
Liebherr logo
Aico logo
Toyota logo
Jysk logo
Vattenfall logo

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

Version 7.4

  • Conditional Formatting's in Pivot tables via Pivot Areas
  • Linked pictures
  • New functions supported in formula calculations: AREAS, TDIST

Version 7.5

  • EPPlus assemblies and NuGet package are signed with a GlobalSign certificate issued to EPPlus Software, ensuring integrity validation

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
Learn more

New features in EPPlus 5/6/7

Features and improvements in the new version.
New features

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
ComponentSource logotype
We have partnered with global software distributor ComponentSource.

Subscribe to our newsletter

Get the latest updates from EPPlus Software

Continue


Developers

New license model, but code still fully available.

EPPlus @ github

Our code repo, issue tracker and developer wiki.

EPPlus @ github

EPPlus @ Stackoverflow

Questions, answers and knowledgesharing.

Browse EPPlus @ Stackoverflow

EPPlus @ Nuget

Install EPPlus from Nuget

Browse EPPlus @ Nuget

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

EPPlus Software supports Doctors without borders