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
软件详情：http://www.apache.org/dyn/closer.cgi/poi/release/
下载地址：http://www.apache.org/dyn/closer.lua/poi/release/bin/poi-bin-3.14.tar.gz
来自:开源中国社区
