New major version was released April 12, 2022
EPPlus 6 introduces support for .NET 6 and has the following new features.
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
...and our developer wiki:Html/Css export
System.Drawing no longer used on non-Windows platforms
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 EPPlus 6 will, by default, not call this library on other platforms.
EPPlus 6 does still have a reference to System.Drawing.Common, but will only use this library on Windows platforms where it still is supported.
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
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!
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.
See the full list of supported functions in our developer wiki.
Version 6.1 was released on November 3, 2022. It has the following new features and improvments:
Q & A
EPPlus 6.0.3 was released on April 12, 2022. Version 6.1 was released on November 3, 2022.