New major version was released October 26, 2023
EPPlus 7 introduces the following new features.
EPPlus 7 has a new calculation engine that support dynamic array formulas and legacy array formulas. This is a feature that has been in high-demand by EPPlus users over the last years.
We have also made many other improvements to the calculation engine, which includes improved precision and performance.
Dynamic array formulas
Dynamic array formulas is a powerful feature that was introduced in Excel in 2018.
EPPlus now supports dynamic array formulas in calculations. This includes support for so called spill over and many new Excel functions that depends upon this functionality. You can also use EPPlus 7 to add/calculate new dynamic array formulas to a workbook.
EPPlus now supports legacy array formulas in calculations. Legacy array formulas has existed in Excel for a long time and requires that the size of the output range is known when you enter the formula.
New functions supported by EPPlus 7
We continously add support for new functions, in EPPlus 7 we have added over 90 new functions.
See the full list of supported functions in our developer wiki .
Improved performance and better support for cross-worksheet references. Support for databars and iconsets has also been improved.
For more details, see our developer wiki .
New Take and Skip methods for worksheet ranges
A new set of methods that makes it easier to access specific rows/columns in a range. These methods are, for example, useful when working with charts, tables and the output of dynamic array formulas.
// newRange will be B3:C8 var newRange = worksheet.Cells["A1:G8"] .SkipRows(2) .SkipColumns(1) .TakeColumns(2);
New sample projects
We have created new sample projects, added new samples and improved the folder structure. There is one project for C# and one for VB.NETEPPlus.Samples.CSharp EPPlus.Samples.VB
Q & A
EPPlus 7.0.0 was released on October 26, 2023.
Yes, if your license still is active/valid.