Apache POI 3.14 发布

发布于 2016-03-07 08:24:02 | 370 次阅读 | 评论: 0 | 来源: 网友投递

这里有新鲜出炉的精品教程，程序狗速度看过来！

Apache POI 开放源码函式库

Apache POI是Apache软件基金会的开放源码函式库，POI提供API给Java程序对Microsoft Office格式档案读和写的功能。

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