This project is read-only.

NPOI 1.2.3

Rating:        Based on 20 ratings
Reviewed:  13 reviews
Downloads: 58291
Change Set: 57448
Released: Nov 12, 2010
Updated: May 4, 2012 by tonyqus
Dev status: Stable Help Icon

Recommended Download

Application binary package
application, 701K, uploaded Nov 13, 2010 - 27524 downloads

Other Available Downloads

Source Code source package
source code, 3748K, uploaded Nov 13, 2010 - 8556 downloads
Example example package
example, 1152K, uploaded Nov 13, 2010 - 18542 downloads
Source Code poifs browser source and binary
source code, 1556K, uploaded Aug 7, 2010 - 3669 downloads

Release Notes

Known Issue (These issues were fixed already)
a. Date cell cannot be modified correctly (The value of WSBool record is incorrectly serialized)
b. NPOI.HSSF.Model.Sheet and NPOI.SS.UserModel.Sheet is confusing (same as NPOI.HSSF.Model.Workbook and NPOI.HSSF.UserModel.Workbook)
c. ProtectSheet cannot work at all

Main changes
a. only one assembly - NPOI.dll
b. Use Ionic.Zip assembly instead
c. Sync POI bug fixes
46776 - Added clone() method to MulBlankRecord to fix crash in Sheet.cloneSheet()(POI-DEVELOPERS)
46547 - Allow addition of conditional formatting after data validation(POI-DEVELOPERS)
45290 - Support odd files where the POIFS header block comes after the data blocks, and is on the data blocks list(POI-DEVELOPERS)
46904 - Fix POIFS issue with duplicate block 0 references on very old BIFF5/BIFF7 files(POI-DEVELOPERS)
47970 - added a method to set arabic mode in HSSFSheet(POI-DEVELOPERS)
47048 - Fixed evaluation of defined names with the 'complex' flag set(POI-DEVELOPERS)
44916 - Allow access to the HSSFPatriarch from HSSFSheet once created(POI-DEVELOPERS)
45672 - improve handling by MissingRecordAwareHSSFListener of records that cover multiple cells (MulBlankRecord and MulRKRecord)(POI-DEVELOPERS)
45698 - Fix LinkTable to tolerate multiple EXTERNSHEET records(POI-DEVELOPERS)
45784 - More fixes to SeriesTextRecord(POI-DEVELOPERS)
46065 - added implementation for VALUE function(POI-DEVELOPERS)
45966 - added implementation for FIND function(POI-DEVELOPERS)
47721 - Added implementation for INDIRECT()
Added implementation for ISNA()
48332 - fixed ColumnInfoRecord to tolerate missing reserved field
45778 - fixed ObjRecord to read ftLbsData properly(POI-DEVELOPERS)
46206 - Fixed Sheet to tolerate missing DIMENSION records(POI-DEVELOPERS)
47384 - Fixed ExternalNameRecord to handle unicode names(POI-DEVELOPERS)
47479 - Fix BoolErrRecord to tolerate incorrect format written by OOO
46199 - More tweaks to EmbeddedObjectRefSubRecord(POI-DEVELOPERS)
47751 - Do not allow HSSF's cell text longer than 32,767 characters
46213 - Fixed FormulaRecordAggregate to gracefully ignore extra StringRecords(POI-DEVELOPERS)
46301 - added pivot table records: SXDI, SXVDEX, SXPI, SXIDSTM, SXVIEW, SXVD, SXVS, et al(POI-DEVELOPERS)
48180 - be more forgiving of short chart records, which skip some unused fields(POI-DEVELOPERS)
46280 - Fixed RowRecordsAggregate etc to properly skip PivotTable records(POI-DEVELOPERS)
46174 - Fixed HSSFName to handle general formulas (not just area references)(POI-DEVELOPERS)
47768 - Implementation of Excel "Npv" functions
47771 - Added method setFunction(boolean) for defined names
47770 - built-in positive formats don't need starting '
47737 - adjust sheet indices of named ranges when deleting sheets
47448 - Allow HSSFEventFactory to handle non-zero padding at the end of the workbook stream
47143 - Fixed OOM in HSSFWorkbook#getAllPictures when reading .xls files containing metafiles
47415 - Fixed PageSettingsBlock to allow multiple PLS records
46269 - Improved error message when attempting to read BIFF2 file(POI-DEVELOPERS)
45290 - Support odd files where the POIFS header block comes after the data blocks, and is on the data blocks list(POI-DEVELOPERS)
46137 - Handle odd files with a ContinueRecord after EOFRecord(POI-DEVELOPERS)

d. NPOI Bug fixes
5010 - Unable to read xls file with pivot table
5139 - SheetExtRecord DataSize is 40
6177 - LeftoverDataException: Intermitend Bug
6341 - System.NullReferenceException on Workbook.Dispose (+Bugfix)
d. Apply NPOI.SS interfaces to NPOI.HSSF namespace

new NPOI examples

POIFS Browser 1.2.3
new features:
a. Identify the record name even if it cannot parse the record
b. Refresh the current file stream

Reviews for this release

For purposes student
by Kiwilbj on Nov 18, 2013 at 2:21 PM
by ilikeboa1225 on Sep 29, 2011 at 7:51 AM
by qingdaoxiangquan on Jul 28, 2011 at 2:34 AM
So far, I'm liking this library very much. It's a far cleaner solution than the Interop methods of the past and still seems to expose most of the advanced features. Thanks!
by brimars on Apr 1, 2011 at 1:27 PM
This space is for reviews only. Use Discussions if you have questions.This space is for reviews only. Use Discussions if you have questions.
by yanzhiyuan on Mar 21, 2011 at 7:07 AM
NPOI is a great library - easy to use and works well (and fast!). This project would really benefit from more comprehensive documentation, though.
by andypaxo on Feb 15, 2011 at 10:20 PM
This is an excellent project... I used in my application development to read and write xls excel formats. I'm waiting for the component which can read and write xlsx files...thanks
by karthikeyan83 on Feb 7, 2011 at 8:35 PM
NPOI is fantastic, but the documentation is functional at best, so I take off a star. A writeup that explains the objects and architecture at a high level and walks through some basic examples (e.g., to explain things like how to use cell styles) is all that's needed.
by jamietre on Jan 6, 2011 at 2:41 PM
Awesome... I have used several times as a replacement to excel automation. What use to take 5 mins now runs in 10 seconds. They have done an amazing job. Thanks!!
by bjohnson8949 on Jan 3, 2011 at 4:23 AM
very smart
by smallbobo on Dec 22, 2010 at 10:01 AM
by iVova on Dec 13, 2010 at 5:11 PM
by ua7418051 on Nov 26, 2010 at 10:20 AM
Worked fine to read and write a xls file.
by almondega on Sep 3, 2010 at 7:06 PM