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 exportJSON export
...and our developer wiki:
Html/Css exportJSON 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 samplesBreaking 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 will the new version be released?
EPPlus 6.0.3 was released on April 12, 2022
If I have a commercial license for EPPlus 5, can I upgrade to EPPlus 6 under my existing license?
Yes