NPOI 1.2.3

Rating:        Based on 20 ratings
Reviewed:  13 reviews
Downloads: 51020
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 - 24993 downloads

Other Available Downloads

Source Code source package
source code, 3748K, uploaded Nov 13, 2010 - 7838 downloads
Example example package
example, 1152K, uploaded Nov 13, 2010 - 14698 downloads
Source Code poifs browser source and binary
source code, 1556K, uploaded Aug 6, 2010 - 3491 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)
45376
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)
46189 - added chart records: CHARTFRTINFO, STARTBLOCK, ENDBLOCK, STARTOBJECT, ENDOBJECT, and CATLAB(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
HideColumnAndRowInXls
ImportXlsToDataTable

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 1:21 PM
     
這是一個很棒的東西!!!
by ilikeboa1225 on Sep 29, 2011 at 6:51 AM
     
想要操作文档,在自己的齐鲁软件大赛的使用这个插件的,,,,,
by qingdaoxiangquan on Jul 28, 2011 at 1: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 12: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 6: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 9: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 7: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 1: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 3:23 AM
     
very smart
by smallbobo on Dec 22, 2010 at 9:01 AM
     
THANKS!!!!!!!!!!!!!
by iVova on Dec 13, 2010 at 4:11 PM
     
goodgoodgoodgoodgood
by ua7418051 on Nov 26, 2010 at 9:20 AM
     
Worked fine to read and write a xls file.
by almondega on Sep 3, 2010 at 6:06 PM