This project is read-only.

NPOI 1.2 final release

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 3682
Released: Apr 12, 2009
Updated: May 22, 2009 by tonyqus
Dev status: Stable Help Icon

Recommended Download

Example NPOI examples 20090412 package.zip
example, 2092K, uploaded Apr 12, 2009 - 1842 downloads

Other Available Downloads

Source Code NPOI 1.2 final release source code.zip
source code, 1883K, uploaded Apr 12, 2009 - 873 downloads
Application NPOI 1.2 final release binary.zip
application, 1515K, uploaded Apr 12, 2009 - 967 downloads

Release Notes

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

Included Examples (20090412 package)
ApplyFontInXls
ColorfulMatrixTable
CreateEmptyExcelFile
CreatePOIFSFile
CreatePOIFSFileWithProperties
DisplayGridlinesInXls
DrawingInXls
ExportXlsToDownload
ExtractStringsFromXls
FillBackgroundInXls
GroupRowAndColumnInXls
InsertPicturesInXls
MergeCellsInXls
MultplicationTableInXls
NumberFormatInXls
RotateTextInXls
SetAlignmentInXls
SetBorderStyleInXls
SetCellCommentInXls
SetCellValuesInXls
SetDateCellInXls
SetPrintSettingsInXls
SetWidthAndHeightInXls
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. .... (too many)

Test Case Information
Total: 950 test cases
Passed: 936 test cases
Pass rate: 98.5%

Unsupported Features
Excel Chart
Pivot Table

Known Bugs
a. Conditional Formating doesn't work as expected
b. HSSFDataFormat.GetFormat return different index for the same format string

Reviews for this release

     
我和能喜欢这个东西 而且很有用
by caiyu0 on Nov 17, 2011 at 3:22 AM