NPOI 1.2.1 release

Rating:        Based on 17 ratings
Reviewed:  13 reviews
Downloads: 39853
Released: Jun 1, 2009
Updated: Nov 7, 2010 by tonyqus
Dev status: Stable Help Icon

Recommended Download

Example NPOI Examples 20090601 package
example, 1095K, uploaded Jun 1, 2009 - 22269 downloads

Other Available Downloads

Application NPOI 1.2.1 release binary
application, 704K, uploaded Jun 1, 2009 - 11156 downloads
Source Code NPOI 1.2.1 release source code
source code, 1624K, uploaded Jun 1, 2009 - 6428 downloads

Release Notes

Vote for NPOI and make it more awesome

Please leave your steps here! Let me know who are using NPOI

Included Libraries
NPOI.Util 1.2.1 Basic assistant class library
NPOI.POIFS 1.2.1 OLE2 format read/write library
NPOI.DDF 1.2.1 Drawing format read/write library
NPOI.SS 1.2.1 Formula evaluation library
NPOI.HPSF 1.2.1 Summary Information and Document Summary Information read/write library
NPOI.HSSF 1.2.1 Excel BIFF format read/write library

Included Examples (20090601 package)
ApplyFontInXls
ColorfulMatrixTable
ConditionalFormattingInXls (new)
CreateEmptyExcelFile
CreatePOIFSFile
CreatePOIFSFileWithProperties
DisplayGridlinesInXls
DrawingInXls
ExportXlsToDownload
ExtractStringsFromXls
FillBackgroundInXls
GenerateXlsFromXlsTemplate (new)
GroupRowAndColumnInXls
InsertPicturesInXls
MergeCellsInXls
MultplicationTableInXls
NumberFormatInXls
RotateTextInXls
SetAlignmentInXls
SetBorderStyleInXls
SetCellCommentInXls
SetCellValuesInXls
SetDateCellInXls
SetPrintSettingsInXls
SetWidthAndHeightInXls
SplitAndFreezePanes (new)
UseBasicFormulaInXls
ZoomSheet

Feature List
a. Read/Write Excel BIFF format
b. able to create a new Excel file in memory stream and save it to a real xls file.
c. Extract all the texts from a Excel file
d. Cell formula evaluation ability, for example,[Cell1]=A1+B1. (NOTE: NOT all the Excel functions are supported)
e. ability to get the tree structure of a Excel format
f. OLE2 document(ActiveX document) read/write ability
g. Add/change/remove properties in Summary Information and Document Summary Information
h. Create Microsoft Drawing shapes in the Excel file
i. Set Cell Styles in the Excel file
j. Insert pictures into the Excel file
k. drawing shapes in Excel
l. group rows and columns
m. Conditional Formatting for cells
n. Print setup settings support
......

Unsupported Features
Excel Chart
Pivot Table
Auto filter on columns
Insert images in header or footer

Fixed Bugs
a. Conditional Formating doesn't work as expected
b. HSSFDataFormat.GetFormat return different index for the same format string
c. Incorrect namespace spelling of NPOI.SS.Formula
d. HSSFCell.ToString() method supports DataFormat now
e. add strong name for all the assembiles
f. HSSFColor.index static variable isn't accessible in VB.NET due to the HSSFColor Index property

Known Bugs (these bugs will be fixed in the 1.2.2 release)
a. ShrinkToFit property is not exposed to user
b. Excel Tab Formatting (color)
c. NPOI doesn't work with a Excel template with macro
d. AutoSizeColumn doesn't work
e. Active selection doesn't work

Reviews for this release

     
I have been playing around with this and it seems very powerful. Thank you for all of you hard work building it!
by spenser723 on Sep 13, 2010 at 6:42 PM
     
Thanks very much for this extensive library. I've only used a few of the features, but I was quickly able to do what I needed based on the examples.
by michaeladamkatz on Jun 7, 2010 at 5:05 AM
     
One of a Great code to use. Easy and Flexible. For Excel Export is one the Best
by sachinnpanchal on May 26, 2010 at 11:35 AM
     
No more Interops, no more orphaned Excel processes. I was able to copy content into a worksheet, set headers & footers, set fonts and styles, borders, you name it. The sample project is very useful for seeing how to use some of the different methods. Huge time saver!
by smushkat on Apr 7, 2010 at 5:59 PM
     
Works just as promised and very easy to use, thanks!!!
by WebAngel on Apr 2, 2010 at 1:21 PM
     
Thank U very much for your library
by kie112 on Feb 6, 2010 at 1:24 AM
     
Great Job Tony et al! Just started using it but it looks like it will do everything I need.
by w4ik on Jan 21, 2010 at 12:24 PM
     
Epic effort! Made manipulating Excel files hell easier :)
by qazek on Jan 5, 2010 at 11:03 PM
     
Excellent!
by cnhzlt on Dec 7, 2009 at 2:08 AM
     
It just works. Excellent project.
by michaelvn on Oct 12, 2009 at 10:36 PM
     
Excellent! powerful and useful
by vegeta on Sep 30, 2009 at 4:05 PM
     
It is powerful! Thanks.
by ammonddp on Sep 4, 2009 at 12:43 AM
     
I had been looking for a good library that reads / writes XLS files for a long time, and finally found NPOI. Great job, the API is simple and efficient. It took me one hour tops to convert from the old Excel automation to NPOI, and now we can finally manipulate spreadsheets on the server. You should definitely advertise more, because I wouldn't have found NPOI if it hadn't been for Leniel's blog.
by Difflam on Aug 6, 2009 at 3:17 AM