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
<PackageReference Include="NPOI" Version="2.4.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
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

Showing the top 10 GitHub repositories that depend on NPOI:

Repository Stars
visualized crawler & ETL IDE written with C#/WPF
The FileHelpers are a free and easy to use .NET library to read/write data from fixed length or delimited records in files, strings or streams
Tabular data exploration and manipulation tool powered by SQLite.
This reporting engine is built on NPOI.
帮助企业快速开发的.net项目框架 Help companies develop project framework
GUI Diff Tool for Excel
Majorsilence Reporting, .NET report designer and viewer. Fork of fyireporting,
Aspose.Words for .NET examples, plugins and showcases

Version History

Version Downloads Last updated
2.4.1 414,762 12/18/2018
2.4.0 123,516 10/28/2018
2.3.0 1,164,456 3/20/2017
2.2.1 664,656 5/31/2016 438,819 2/22/2015
2.1.3 47,769 12/31/2014
2.0.6 164,346 4/12/2014
1.2.5 127,308 7/29/2012
1.2.4 14,166 11/15/2011
1.2.3 11,683 1/12/2011