NPOI 2.0.6

Prefix Reserved

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.0.6

NuGet\Install-Package NPOI -Version 2.0.6

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.0.6" />

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

<PackageVersion Include="NPOI" Version="2.0.6" />
                    

                            Directory.Packages.props

<PackageReference Include="NPOI" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add NPOI --version 2.0.6

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

#r "nuget: NPOI, 2.0.6"

#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.

#:package NPOI@2.0.6

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=NPOI&version=2.0.6
                    

                            Install as a Cake Addin

#tool nuget:?package=NPOI&version=2.0.6
                    

                            Install as a Cake Tool

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

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.

- SharpZipLib (>= 0.86.0)

NuGet packages (1.0K)

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.	4.0M
ExcelMapper An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.	3.1M
JoreNoe Redis并发优化	1.7M
HIC.RDMP.Plugin Core package for plugin development	480.4K
BaseLibrary.ClassLibraryStand Package Description	379.4K

GitHub repositories (62)

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

Repository	Stars
Uahh/ToastFish 一个利用摸鱼时间背单词的软件。	6.0K
laochiangx/Common.Utility Various helper class	5.2K
Planshit/Tai 👻 在Windows上统计软件使用时长和网站浏览时长	4.5K
rmcrackan/Libation Libation: Liberate your Library	4.2K
ferventdesert/Hawk visualized crawler & ETL IDE written with C#/WPF	3.2K
mini-software/MiniExcel Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)	3.1K
SciSharp/BotSharp AI Multi-Agent Framework in .NET	2.8K
liukuo362573/YiShaAdmin 基于 .NET Core MVC 的权限管理系统，代码易读易懂、界面简洁美观	2.5K
dotnetcore/Magicodes.IE Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.	2.2K
grandnode/grandnode Open source, headless, multi-tenant eCommerce platform built with .NET Core, MongoDB, AWS DocumentDB, Azure CosmosDB, Vue.js.	1.9K
CoreUnion/CoreShop 基于 Asp.Net Core 8.0、Uni-App开发，支持可视化布局的小程序商城系统，前后端分离，支持分布式部署，跨平台运行，拥有分销、代理、团购、拼团、秒杀、直播、优惠券、自定义表单等众多营销功能，拥有完整SKU、下单、售后、物流流程。支持一套代码编译发布微信小程序版、H5版、Android版、iOS版、支付宝小程序版、字节跳动小程序版、QQ小程序版等共10个平台。	1.3K
GZTimeWalker/GZCTF The GZ::CTF project, an open source CTF platform.	1.2K
grandnode/grandnode2 E-commerce platform built with ASP.NET Core using MongoDB for NoSQL storage	1.2K
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	1.2K
HenJigg/wpf-abp Cross-platform mobile project and WPF client based on ABP framework Xamarin.Forms	963
mganss/ExcelMapper An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.	858
ntxinh/AspNetCore-DDD Full ASP.NET Core 8.0 LTS application with DDD, CQRS and Event Sourcing	853
skanmera/ExcelMerge GUI Diff Tool for Excel	767
HeBianGu/WPF-ControlBase Wpf封装的自定义控件资源库	752
donnytian/Npoi.Mapper Use this tool to import or export data with Excel file. The tool is a convention based mapper between strong typed object and Excel data via NPOI.	624

Version	Downloads	Last Updated
2.7.4	50,156	6/29/2025
2.7.3	891,751	3/23/2025
2.7.2	2,402,630	11/9/2024
2.7.1	3,177,347	7/3/2024
2.7.0	3,162,700	3/25/2024
2.6.2	4,670,879	9/11/2023
2.6.1	1,418,368	7/11/2023
2.6.0	6,163,572	11/17/2022
2.5.6	13,708,439	4/26/2022
2.5.5	5,910,737	10/25/2021
2.5.4	2,138,780	7/29/2021
2.5.3	2,440,258	4/18/2021
2.5.2	2,839,119	12/5/2020
2.5.1	6,206,777	4/4/2020
2.4.1	9,961,572	12/18/2018
2.3.0	3,944,308	3/20/2017
2.2.1	2,072,936	5/31/2016
2.1.3.1	1,495,092	2/22/2015
2.1.3	142,819	12/31/2014
2.0.6	446,000	4/12/2014
1.2.5	413,423	7/29/2012
1.2.4	85,943	11/15/2011
1.2.3	90,611	1/12/2011

New features
a. Support Scatter chart in XSSF (xlsx) (other chart types are not supported yet)
b. Extract pictures from Excel (xlsx)
c. XWPF becomes stabler than before
d. Able to support xml:space="preserve" attribute
e. Add mono assembly in the release package
f. file generated by NPOI will contain NPOI tags in custom properties to identify the generator
g. Adjust some XWPF interfaces
h. implement XSSFCell.IsMergedCell
i. IWorkbook implements IList<ISheet>

Sample changes
a. add new samples like BigGridTest, WritePerformanceTest to test performance
b. add ScatterChart to show how to create Scatter chart
c. add LinkedDropDownList for both XSSF and HSSF
d. add MonthlySalaryReport to show how to use formula in XSSF
e. add CreateCustomProperties to show how to use custom props in XSSF and XWPF

Bug fixes
a. fix shift row issue in XSSFSheet
b. fix performance issue due to XmlSerializer. NPOI is getting rid of XmlSerializer.
c. reading/writing CT_Drawing
d. fix ddd pattern issue in CellDateFormatter
e. Change some common interfaces in NPOI.SS
f. fix OutOfMemory issue in MemoryPackagePart
g. Able to read AbsoluteAnchor, OneCellAnchor, TwoCellAnchor in drawing.xml
h. Formula will be calculated automatically after generation
i. improve performance for XSSF while creating new rows
For detail, please read https://npoi.codeplex.com/discussions/443655
j. fix name encoding issue of custom properties in HSSF
For detail, please read https://npoi.codeplex.com/workitem/12296
k. fix exception in HSSFRows.RemoveAllCells
l. fix CellStyle Hashtable comparison issue in class HSSFCellUtil. This can help prevent over 4000 styles issue from code.
m. Fix globalization issue in ExpandedDouble
n. fix a lot of xml serialization issue for OOXML
o. implement XSSFCell.IsMergedCell
p. IWorkbook implements IList<ISheet>