New features after EPPlus 4

Features and technical overview

News in EPPlus 5/6/7/8

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
In-cell pictures - including support for the IMAGE function. New!

Import/Export

Export html/css from worksheet ranges and tables
Export json data from worksheet ranges and tables
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

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.
Hundreds of fixed issues and minor improvements

Miscellaneous new features

Support all Excel 2019 chart types with the new, modern styling
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
Digital signatures - including support signature lines and stamps. New!
OLE Objects - embed or link external files. New!
 Back