NPOI 2.4.0

Neuzilla is the studio behind NPOI.

Neuzilla provides software customization and consulting service. For details, please contact

There is a newer version of this package available.
See the version list below for details.
Install-Package NPOI -Version 2.4.0
dotnet add package NPOI --version 2.4.0
paket add NPOI --version 2.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

New features
NET Standard 2.0 support
stop .NET Framework 2.0 support (some contributed code start using System.Linq)
Add Excel function support for AVERAGEIF and AVERAGEIFS
CopySheet support in XSSFSheet
Implemented OMath formula edit/creation in XWPF
Support line and bar mixed chart

BUG Fixes
fix SharpZipLib 0.86 dependency issue in .NET Framework
solve SecurityRules issue since .NET 4.0 while using AllowPartiallyTrustedCallers
AutoFilter colId must have value even when it equals 0
Fix NUnit Test cases in VS2017 (development purpose only)
MathX.Round() - fixing some instances of incorrect rounding and adding
Fix Word processing fields issue in XWPF
Fix a bug of 'adding picture to word' failed

Version History

Version Downloads Last updated
2.4.1 61,739 12/18/2018
2.4.0 60,699 10/28/2018
2.3.0 914,945 3/20/2017
2.2.1 501,058 5/31/2016 386,058 2/22/2015
2.1.3 35,304 12/31/2014
2.0.6 135,962 4/12/2014
1.2.5 106,831 7/29/2012
1.2.4 12,295 11/15/2011
1.2.3 10,249 1/12/2011