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

There is a newer version of this package available.
See the version list below for details.
Install-Package NPOI -Version 2.0.6
dotnet add package NPOI --version 2.0.6
<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
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

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>

Showing the top 10 GitHub repositories that depend on NPOI:

Repository Stars
ferventdesert/Hawk
visualized crawler & ETL IDE written with C#/WPF
Jimmey-Jiang/Common.Utility
比较全面的c#帮助类,各种功能性代码。
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
akiver/CSGO-Demos-Manager
No Description.
electroly/sqlnotebook
Tabular data exploration and manipulation tool powered by SQLite.
hanzhaoxin/ExcelReport
This reporting engine is built on NPOI.
whywhy898/DDit-Rapid-Development-Framework
帮助企业快速开发的.net项目框架 Help companies develop the.net project framework
skanmera/ExcelMerge
GUI Diff Tool for Excel
majorsilence/My-FyiReporting
Majorsilence Reporting, .NET report designer and viewer. Fork of fyireporting,
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases

Version History

Version Downloads Last updated
2.4.1 339,471 12/18/2018
2.4.0 113,297 10/28/2018
2.3.0 1,121,989 3/20/2017
2.2.1 640,521 5/31/2016
2.1.3.1 430,156 2/22/2015
2.1.3 45,380 12/31/2014
2.0.6 159,677 4/12/2014
1.2.5 123,675 7/29/2012
1.2.4 13,787 11/15/2011
1.2.3 11,500 1/12/2011
Show less