.NET Framework 2.0
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.
paket add NPOI --version 2.0.6
#r "nuget: NPOI, 2.0.6"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. 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.0.6

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

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 Versions
.NET Framework net20 net35 net40 net403 net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (669)

Showing the top 5 NuGet packages that depend on NPOI:

Package Downloads

Convention-based mapper between strong typed object and Excel data via NPOI.


Map POCOs to Excel files


Consumes a generic inventory document store to be used in PMoney applications.


Extension for FileHelpers to support Excel read/write operations using NPOI Library www.filehelpers.net



GitHub repositories (43)

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

Repository Stars
🛠「Watt Toolkit」是一个开源跨平台的多功能 Steam 工具箱。
Various helper class
visualized crawler & ETL IDE written with C#/WPF
基于 .NET Core MVC 的权限管理系统,代码易读易懂、界面简洁美观
Version Downloads Last updated
2.6.0 18,832 11/17/2022
2.6.0-rc-3 7,277 9/24/2022
2.5.6 1,635,389 4/26/2022
2.5.5 2,297,968 10/25/2021
2.5.4 1,115,915 7/29/2021
2.5.3 1,461,017 4/18/2021
2.5.2 1,708,838 12/5/2020
2.5.1 3,739,467 4/4/2020
2.4.1 5,637,325 12/18/2018
2.3.0 2,997,589 3/20/2017
2.2.1 1,458,426 5/31/2016 988,426 2/22/2015
2.1.3 113,517 12/31/2014
2.0.6 349,573 4/12/2014
1.2.5 295,870 7/29/2012
1.2.4 41,059 11/15/2011
1.2.3 30,952 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>