C# 使用 NPOI 库读写 Excel 文件

2.2.1 (May,2016) Bug Fixes - Fix a lot of serialization issue of ooxml issue - Fix phonetic guides tag reading/writing issue - Fix XWPFRun SetText exception issue - Fix xml security issue - Optimize memory for AutoResizeColumn - Fix sqref property is missing on ProtectedRange - Fix drawing ooxml issue and cell value bug - Fix numFmtId property issue on NumFmt node - Fix ooxml issues for RadarChart and CellStyle - Fix xfrm namespace issue in ooxml - Fix ScatterChart issue in ooxml - Fix ooxml bugs in Vml entities - fix bug when call ISheet.RemoveRow, it removes a wrong row - Don't close zip stream when zipoutputstream finish writing 2.2.0 (Aug, 2015) New Feature 1. Implement FIXED, PROPER, DMIN and DGET functions 2. XSSF support for evaluating formula references to other Workbooks 3. Read text from SDTs at the table cell level, including (sometimes) Cover Page, Table of Contents and Bibliography 4. Double Strikethrough support for XWPF runs 5. XSSFSheet support for getDrawingPatriarch(), alongside the existing createDrawingPatriarch() method 6. Start on common interfaces for Paragraphs and Character Runs for XWPF 7. Basic text extractor for older Excel 4,5 and 95 formats 8. Add NPOIFS in-place write support, including updating the contents of existing entries 9. Support loading .xlsx files with no Styles Table POI Bug fixes 57880 - Handle >32,767 cell styles and formats in XSSF (file format limit is 64,000) 57826 - If a XSSF shape has a buFont but no bullet character, mirror Excel and treat as un-bulleted 56017 - Fix shifting comments with shifted rows 56295 - Fix cloning of styles across workbooks and handling of default value of attribute applyFill 56380 - Remove limitation of 1024 comments per Workbook 56467 - Fix cloning of sheets with pictures 57171 - Adjust the active sheet in setSheetOrder() 57163 - Adjust the active sheet in removeSheet() 57165 - Avoid PartAlreadyExistsException when removing/cloning sheets 57196 - Resolve RefEval to it's inner ValueEval in Hex2Dec 57482 - Handle XSLX files with no shared strings table in read-only mode 46898 - XSSF: Return #VALUE! for circular references. 46912 - Add methods to query outline level for HSSF and XSSF 49541 - Mapping of symbol characters to unicode equivalent 57007 - Add initial implementations of DMIN and DGET functions 57373 - Fix get/setFirstVisibleTab() for XSSFWorkbook 57231 - Add missing ArrayRecord.clone() 56511 - Fix NullPointerException for RichText strings with no formatting for some runs. 56888 - XSSFDataValidation ignores "allow blank" read from sheet, assumes true 57236 - 57254 - XWPF: Correctly build internal list of styles when styles are added 57312 - XWPF: Add check for null value of underline w:val 57355 - 57164 - XSSFDrawing.createCellComment() does not honor dx and dy values passed in 57003 - Add implementation of function FIXED 57185 - Correct naming from "Serie" to "Series" 57010 - Add implementation of function PROPER 55280 - XSSF: Greatly improve performance of shifting rows in sheets with many merged regions. 48195 - Formulas: Fix incorrect evaluation of IF() with ROW()/COLUMN() as else-result. 56914 - XSSFRowShifter.updateConditionalFormatting throws IOOBE when there are more than 1 CTConditionalFormatting 51222 - XSSFColor.getARGBHex() returns wrong color for Excel 2007 xlsx file 56864 - XWPFLatentStyles.isLatentStyle always returns true if there is at least 1 lsdException 57151 - And documentation and validation in CellRangeAddress to prevent invalid row/column combinations 2.1.3.1 (Feb., 2015) Bug Fixes a. fix word serialization issues b. fix CloneStyleFrom issue c. Fix vertical alignment default value for XSSFCell d. fix setAutoFilter change range issue e. fix EDate function f. fix FormatException in FormulaParser g. fix Comment random Shape issue (comment serialization issue) h. fix not be able to unlock the cell issue POI BUG FIXES 55729 - DataFormatter should format Error cells, returning the Excel error string 49237 - HSSF Row Style XfIndex is 12 not 16 bits of data 54607 - NullPointerException in XSSFSheet.getTopRow() when the top row is 1 55745 - fix handling of tables in XSSF if there are comments as well 54673 - Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF 55047 - REPT formula support 55042 - COMPLEX formula support 55041 - CODE formula support 54508 - EDATE formula support 53966 - IfError support (from Analysis Toolpak) 54402 - IfError handling of indirect references New feature a. Add ReplaceText to XWPFParagraph and XWPFRun b. adjust ExcelExtractor interface c. Improving comment missing handling in HSSFSheet d. copy hyperlink in CopySheet and fix some bugs e. Implement ChartSheet in OpenXmlFormats f. Implement shrinktofit for XSSF 2.1.3 (Dec., 2014) Bug Fixes a. fix 2 charts insert in the same sheet issue b. fix a lot of Excel 2007 serialization issues c. fix some Word 2007 serialiation issues d. fix RemoteSheetAt bug e. support changing background in XWPF f. fix Uri-related issues on Mono New examples SetIsRightToLeftInXlsx - show how to use IsRightToLeft property ExtractPicturesFromXlsx - show how to extract pictures from Excel 2007 file SetRowStyle - show how to set whole row style with simple code 2.1.1 (Jun., 2014) New Features a. XSSFSheet.CopySheet b. Excel2Html for XSSF and HSSF c. insert picture in word 2007 d. Implement IfError function in formula engine Bug Fixes a. fix conditional formatting issue b. fix ctFont order issue c. fix vertical alignment issue in XSSF d. add IndexedColors to NPOI.SS.UserModel e. fix decimal point issue in non-English culture f. fix SetMargin issue in XSSF g.fix multiple images insert issue in XSSF h.fix rich text style missing issue in XSSF i. fix cell comment shape (big arrow) in XSSF j. WorkbookFactory for Excel 2007 doesn't occupy file. k. fix XSSFCell.IsMergedCell l. fix incorrect page margin value due to different culture m. fix HSSFSheet.CopyTo doesn't copy rich text in cells n. fix scroll bar and tabs missing in previous 2.1 release New examples a. XSSF.DownloadXlsx b. XSSF.ConditionFormats c. XSSF.LineChart d. XWPF.InsertPicturesInWord 2.0 [v2.0.6] (Jan., 2014) a. fix a lot of xml serialization issue for OOXML (2.0.5 will corrupt some xlsx and docx files) b. implement XSSFCell.IsMergedCell c. IWorkbook implements IList<ISheet> 2.0 Beta 2 [v2.0.5] (Dec, 2013) 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 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 https://npoi.codeplex.com/discussions/443655 j. fix name encoding issue of custom properties in HSSF For detail, please read https://npoi.codeplex.com/workitem/12296 k. fix exception in HSSFRows.RemoveAllCells l. fix CellStyle Has