NPOI 2.1.3.1

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

This package has been deprecated as it is legacy and is no longer maintained.

There is a newer version of this package available.
See the version list below for details.

dotnet add package NPOI --version 2.1.3.1

NuGet\Install-Package NPOI -Version 2.1.3.1

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

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

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

paket add NPOI --version 2.1.3.1

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

#r "nuget: NPOI, 2.1.3.1"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install NPOI as a Cake Addin
#addin nuget:?package=NPOI&version=2.1.3.1

// Install NPOI as a Cake Tool
#tool nuget:?package=NPOI&version=2.1.3.1

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

Neuzilla is the studio behind NPOI. For detail, you can check http://blog.neuzilla.com/

Neuzilla provides onsite/offsite hand-on training, troubleshooting and software customization. For details, please contact support@neuzilla.com

This project is the .NET version of POI from Apache Foundation. NPOI can read and write xls (Excel 97-2003), xlsx(Excel 2007+) and docx(Word 2007+)

Product	Compatible and additional computed target framework versions.
.NET Framework	net20 is compatible. net35 was computed. net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (892)

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.	2.5M
ExcelMapper An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.	1.8M
HIC.RDMP.Plugin Core package for plugin development	427.1K
BaseLibrary.ClassLibraryStand Package Description	352.8K
Mooho.Base 摩赫基础框架	300.3K

GitHub repositories (56)

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

Repository	Stars
laochiangx/Common.Utility Various helper class	5.0K
Uahh/ToastFish 一个利用摸鱼时间背单词的软件。	4.9K
Planshit/Tai 👻 在Windows上统计软件使用时长和网站浏览时长	3.5K
ferventdesert/Hawk visualized crawler & ETL IDE written with C#/WPF	3.1K
liukuo362573/YiShaAdmin 基于 .NET Core MVC 的权限管理系统，代码易读易懂、界面简洁美观	2.3K

Version	Downloads	Last updated
2.7.0	101,348	3/25/2024
2.6.2	1,800,691	9/11/2023
2.6.1	699,949	7/11/2023
2.6.0	3,711,454	11/17/2022
2.5.6	7,125,035	4/26/2022
2.5.5	4,579,391	10/25/2021
2.5.4	1,822,101	7/29/2021
2.5.3	2,085,714	4/18/2021
2.5.2	2,451,934	12/5/2020
2.5.1	5,374,464	4/4/2020
2.4.1	7,823,342	12/18/2018
2.3.0	3,537,523	3/20/2017
2.2.1	1,831,288	5/31/2016
2.1.3.1	1,272,578	2/22/2015
2.1.3	129,667	12/31/2014
2.0.6	415,434	4/12/2014
1.2.5	373,915	7/29/2012
1.2.4	71,257	11/15/2011
1.2.3	50,719	1/12/2011

Bug Fixes
a. fix word serialization issues
b. fix CloneStyleFrom issue
c. Fix vertical alignment default value for XSSFCell
d. fix setAutoFilter change range issue
e. fix EDate function
f. fix FormatException in FormulaParser
g. fix Comment random Shape issue (comment serialization issue)
h. fix not be able to unlock the cell issue

POI BUG FIXES
55729 - DataFormatter should format Error cells, returning the Excel error string
49237 - HSSF Row Style XfIndex is 12 not 16 bits of data
54607 - NullPointerException in XSSFSheet.getTopRow() when the top row is 1
55745 - fix handling of tables in XSSF if there are comments as well
54673 - Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
55047 - REPT formula support
55042 - COMPLEX formula support
55041 - CODE formula support
54508 - EDATE formula support
53966 - IfError support (from Analysis Toolpak)
54402 - IfError handling of indirect references

New feature
a. Add ReplaceText to XWPFParagraph and XWPFRun
b. adjust ExcelExtractor interface
c. Improving comment missing handling in HSSFSheet
d. copy hyperlink in CopySheet and fix some bugs
e. Implement ChartSheet in OpenXmlFormats
f. Implement shrinktofit for XSSF