This project is read-only.

NPOI 2.0

Rating:        Based on 3 ratings
Reviewed:  3 reviews
Downloads: 52036
Released: Jan 5, 2014
Updated: Jan 16, 2015 by tonyqus
Dev status: Stable Help Icon

Recommended Download

Application NPOI 2.0 binary package
application, 3535K, uploaded Jan 5, 2014 - 33621 downloads

Other Available Downloads

Example NPOI 2.0 examples package
example, 3729K, uploaded Dec 3, 2013 - 18415 downloads

Release Notes

NPOI User Group:

Assembly version: 2.0.6

Provide 2 assembly versions: .net 2, .net 4

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

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

Winhost low-cost hosting
Cheap ASP.NET Hosting - $4.95/Month - Click Here!

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
j. fix name encoding issue of custom properties in HSSF
For detail, please read
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>

To get the source code, please visit

Reviews for this release

亲,2.0版本的 垂直居中 不好用。 设置 VerticalAlignment.Center 之后,是底部居中。
by jelly1989 on Feb 13, 2014 at 7:06 AM
Great project. Performs well.
by beb77777 on Feb 7, 2014 at 5:26 PM
The more I look, the more I like. Being able to create multi-line comments (added in this release) is icing on the cake!
by NJBrad on Jan 11, 2014 at 9:42 PM