EPPlus 6

New major version was released April 12, 2022

EPPlus 6 introduces support for .NET 6 and has the following new features.

Html/Css/JSON export

EPPlus 6 comes with new features for exporting tables, cell ranges and styles to html and css. There is also a new export of cell ranges to JSON.

See our new samples website:

Html/Css export
JSON export

...and our developer wiki:

Html/Css export
JSON export

System.Drawing dependency removed

Previous versions of EPPlus were dependent of the System.Drawing.Common library for handling of images and text measurements. As Microsoft has announced that this library is no longer supported on Non-Windows platforms we have removed this dependency.

New internal implementation

In EPPlus 6 the functionality previously provided by System.Drawing has been replaced by an internal, managed code only implementation. This has many advantages, especially on Non-Windows platforms - see this example where EPPlus 6 runs in client side Blazor (web assembly):

Blazor sample 1

...or our new Docker samples for EPPlus 6:

EPPlus Docker samples
Breaking changes

Since previous versions of EPPlus have classes from the System.Drawing namespace in their public interfaces these method-signatures have been removed in EPPlus 6. This affects for example the ExcelDrawing.AddPicture method.

See this wiki-article with more details: Breaking changes

New image formats supported

We have added support for new image formats in EPPlus 6, here is the full list of supported formats:

  • Svg - New!
  • Ico - New!
  • WebP - New!
  • Jpg
  • Bmp
  • Gif
  • Png
  • Tif
  • Emf
  • Wmf

New functions supported in formula calculation

We continously add support for new functions, in EPPlus 6 we have added over 30 new functions - mainly in the financial and statistical categories.

BETADIST BETA.DIST BETAINV
BETA.INV CHIDIST CHISQ.DIST.RT
CHIINV CHISQ.INV CHISQ.INV.RT
CORREL EXPONDIST EXPON.DIST
FISHER FISHERINV FORECAST
FORECAST.LINEAR GAUSS GEOMEAN
HARMEAN INTERCEPT KURT
PEARSON PHI RSQ
SKEW SKEW.P STANDARDIZE
ACCRINT ACCRINTM TBILLEQ
TBILLPRICE TBILLYIELD

See the full list of supported functions in our developer wiki.

Q & A

When were the new major version released?
EPPlus 6.0.3 was released on April 12, 2022. Version 6.1 was released on November 3, 2022.
If I have a commercial license for EPPlus 5, can I upgrade to EPPlus 6 under my existing license?
Yes
How do I upgrade from previous versions to EPPlus 6?
See these two pages in our developer wiki: