Apache POI 3.14 发布

Apache POI 3.14 发布了，Apache POI是一个开源的Java读写Excel、WORD等微软OLE2组件文档的项目。目前POI已经有了Ruby版本。

结构：

• HSSF － 提供读写Microsoft Excel XLS格式档案的功能。

• XSSF － 提供读写Microsoft Excel OOXML XLSX格式档案的功能。

• HWPF － 提供读写Microsoft Word DOC97格式档案的功能。

• XWPF － 提供读写Microsoft Word DOC2003格式档案的功能。

• HSLF － 提供读写Microsoft PowerPoint格式档案的功能。

• HDGF － 提供读Microsoft Visio格式档案的功能。

• HPBF － 提供读Microsoft Publisher格式档案的功能。

• HSMF － 提供读Microsoft Outlook格式档案的功能。

改进日志：

•  59056 - Render individual slideshow shapes

•  59074 - ExtractorFactory should give a more helpful exception on old Excel files too old for ExcelExtractor

•  57989 - XSSFChart support for setting chart titles

•  59030 - Prevent NPE in XWPFTableCell's getVerticalAlignment() from Prasad Babu

•  59021 - XSSFSheetXMLHandler fails to extract content if namespace is included in qName

•  56345 - Reject single-cell merged regions

•  58339 - Make OFFSET() allow missing optional height and width parameters

•  github-27 - Handle documents with a picture-only header

•  58996 - Regression caused by fixing bug 56295: Don't try to unset fill color if it is not set to avoid invalid access inside the Xml structures

•  57034 - Cell.setCellValue((String)null) should be treated as an empty cell on SXSSF as well, to avoid a NPE when autosizing columns

•  XSLF - fixed NPE when adding pictures with existing non-picture media files (e.g. movies)

•  58885 - Fixed preformance regression after fixing bug 58443 when adding a merged region to an XSSFSheet.

•  Raised xmlsec version to 2.0.6

•  47291 - Cannot open link correctly which insert in ppt

•  41047 - Support hyperlinks in HSLF shapes and textruns

•  58879 - Return SpreadsheetVersion from Workbook

•  Fix NPE when calling HSLFTextRun.setHorizontalCentered()

•  58633 - Set multiple cell style properties at once

•  56004 - Support for WMF rendering

•  56892 - Add API for inserting ignored warnings into XSSF sheets. This can be used e.g. to suppress 'number stored as text' warnings.

•  58847 - Getters/setters/removers for the additional well-known document summary information properties from Office 12

•  57796 - Support hyperlink extraction when rendering slides

•  54916 - POI does not always read all the slides in pptx files

•  58043 - Provide some compatibility between HSSF and XSSF in regards to values for CellStyle.setRotation()

•  58067 - XWPF: don't return deleted text when document is in review-mode

•  58618 - XWPFParagraph insertNewRun and removeRun work incorrectly for runs after hyperlink/field runs

•  58760 - Non-standard namespace-key breaks parsing XLSX files

•  58746 - Fix missing adjustment of formulas when sheet-ordering is changed.

•  58616 - Try to initialize with empty password if not done before

•  Fix some cases where file-handles were left open, mostly when failing to parse documents

•  55030 - RichTextRun getFontName can not get chinese font name

•  56570 - RecordType has repeat by code type 3009

•  58159 - getHeaderText() and getFooterText() duplicate text in sheet.getTextRuns()

•  58775 - Set maximum number of data formats to avoid corrupted workbook

•  58778 - Override built-in number formats in XSSFWorkbooks

•  58733 - New AIOOBE in getCell while iterating through a table in PPT

•  58718 - Master styles not initialized when running multithreaded

下载地址：

• poi-bin-3.14.tar.gz          (19MB, signed)          
           MD5 checksum:  7bf2f5e4eb86cad4e9437bbab8eb7719          
           SHA1 checksum: 35920092f01659cbc2268979c697672852f4e790

• poi-bin-3.14.zip          (27MB, signed)          
           MD5 checksum: c4264cce7a430317f7dfc82fa885566d          
           SHA1 checksum: 4a20c30c98c88ff91feb84fb128eb0dd1851de65

• poi-src-3.14.tar.gz          (67MB, signed)          
           MD5 checksum: c062938165943683e3b77ff7f2a39e04          
           SHA1 checksum: 046fc63a857f97ca5b7b5e5e687e1a8696bf3f44

• poi-src-3.14.zip          (71MB, signed)          
           MD5 checksum: 17d1ac6261ab2f26e0af786c94033158          
           SHA1 checksum:dc34d10745d1bcff88044509e0bda54c137b30d0