NPOI 2.5.2

Install-Package NPOI -Version 2.5.2

dotnet add package NPOI --version 2.5.2

<PackageReference Include="NPOI" Version="2.5.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add NPOI --version 2.5.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: NPOI, 2.5.2"

For F# scripts that support #r syntax, copy this into the source code to reference the package.

Documentation

To get started with NPOI, you can visit NPOI examples repository

Don't forget to wash your hand during the pandemic season. God bless you!

To get started with NPOI, you can visit NPOI examples repository

Don't forget to wash your hand during the pandemic season. God bless you!

Release Notes

#448 Add ifs, maxifs, minifs functions to analysis tool pack
#410 fix Match function for compatible
#423 AddPicture doesn't work, corrupts DOCX file
#397 LocalUtil.GetUserTimeZone NullReferenceException
#167 Unable to add image to a word document header or footer using XWPF
#346 NullReferenceException when copying sheet in some Excel files
#413 fix: Rich strings hash for texts with the color set as RGB
#444 Update RANDBETWEEN
#158 NPOI Excel Merging Causing “Repaired Records”
#345 Excel unreadable content error after editing existing file
#358 Remove static locale state
#367 fix incorrect footnote handling
#372 NPOI requires GDI+ dependency even on sheet creation without using column auto-sizing
#281 InvalidOperationException on XSSFSheet.GetColumnStyle
#377 AutoSizeColumnTracker to Lazy, fix build errors
#339 improve performance of CreateRow for bigger excel sheets

Dependencies

.NETFramework 4.5
- Portable.BouncyCastle (>= 1.8.6)
- SharpZipLib (>= 1.2.0)
.NETStandard 2.0
- Portable.BouncyCastle (>= 1.8.6)
- SharpZipLib (>= 1.2.0)
- System.Configuration.ConfigurationManager (>= 4.5.0)
- System.Drawing.Common (>= 4.5.0)
.NETStandard 2.1
- Portable.BouncyCastle (>= 1.8.6)
- SharpZipLib (>= 1.2.0)
- System.Configuration.ConfigurationManager (>= 4.5.0)
- System.Drawing.Common (>= 4.5.0)

Used By

NuGet packages (417)

Showing the top 5 NuGet packages that depend on NPOI:

Package	Downloads
Npoi.Mapper Convention-based mapper between strong typed object and Excel data via NPOI.	292.4K
ExcelMapper Map POCOs to Excel files	146.2K
PMoney.Inventory Consumes a generic inventory document store to be used in PMoney applications.	126.8K
Infodinamica.Framework.Exportable Proyecto que permite exportación de listas genericas (IEnumerable) a Excel	90.2K
Objectivity.Test.Automation.Common.NUnit [DEPRECATED] Use Install-Package Ocaramba.Features Install-Package Ocaramba.MsTest Install-Package Ocaramba.NUnit Install-Package Ocaramba.xUnit instead	80.2K

GitHub repositories (25)

Showing the top 5 popular GitHub repositories that depend on NPOI:

Repository	Stars
Jimmey-Jiang/Common.Utility Various helper class	3.8K
ferventdesert/Hawk visualized crawler & ETL IDE written with C#/WPF	2.8K
grandnode/grandnode Free and Open Source Ecommerce Shopping Cart solution based on ASP.NET CORE and MongoDB	1.6K
liukuo362573/YiShaAdmin 基于 .NET Core MVC 的权限管理系统，代码易读易懂、界面简洁美观。演示版 http://106.14.124.170/admin	1.1K
MarcosMeli/FileHelpers 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	911

Version History

Version	Downloads	Last updated
2.5.2	151,935	12/5/2020
2.5.1	1,258,807	4/4/2020
2.4.1	2,927,036	12/18/2018
2.3.0	1,983,497	3/20/2017
2.2.1	1,046,413	5/31/2016
2.1.3.1	677,420	2/22/2015
2.1.3	86,192	12/31/2014
2.0.6	274,302	4/12/2014
1.2.5	199,132	7/29/2012
1.2.4	21,738	11/15/2011
1.2.3	17,199	1/12/2011