NPOI 2.1.3.1

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+)

There is a newer version of this package available.
See the version list below for details.
Install-Package NPOI -Version 2.1.3.1
dotnet add package NPOI --version 2.1.3.1
<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"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Release Notes

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

Dependencies

This package has no dependencies.

NuGet packages (422)

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.
ExcelMapper
Map POCOs to Excel files
PMoney.Inventory
Consumes a generic inventory document store to be used in PMoney applications.
Infodinamica.Framework.Exportable
Proyecto que permite exportación de listas genericas (IEnumerable) a Excel
Objectivity.Test.Automation.Common.NUnit
[DEPRECATED] Use Install-Package Ocaramba.Features Install-Package Ocaramba.MsTest Install-Package Ocaramba.NUnit Install-Package Ocaramba.xUnit instead

GitHub repositories (25)

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

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

Version History

Version Downloads Last updated
2.5.2 185,407 12/5/2020
2.5.1 1,312,718 4/4/2020
2.4.1 2,974,981 12/18/2018
2.3.0 2,005,037 3/20/2017
2.2.1 1,053,771 5/31/2016
2.1.3.1 683,709 2/22/2015
2.1.3 87,070 12/31/2014
2.0.6 276,694 4/12/2014
1.2.5 201,705 7/29/2012
1.2.4 21,914 11/15/2011
1.2.3 17,319 1/12/2011
Show less