Apache POI-3.14.jar是java實現文件批量導入導出的多功能工具包包,多用于拓展jdk的導入導出、寫入讀取excel表格功能,兼容xls、xlsx,需要的程序猿們快來IT貓撲下載使用吧!

Apache POI是什么

Apache POI是一個開源的Java讀寫Excel、word等微軟OLE2組件文檔的項目。

Apache POI 3.14 內容

Apache POI是Apache軟件基金會的開放源碼函式庫,POI提供API給Java程序對Microsoft office格式檔案讀和寫的功能。

POI的jar包導入

jar包版本使用poi-3.14和poi-ooxml-3.14。目前最新的版本是3.16。因為3.15以后相關api有更新,部分操作可能不一樣,大家注意下。

Apache POI3.14.jar結構

HSSF - 提供讀寫Microsoft Excel格式檔案的功能。

XSSF - 提供讀寫Microsoft Excel OOXML格式檔案的功能。

HWPF - 提供讀寫Microsoft Word格式檔案的功能。

HSLF - 提供讀寫Microsoft Powerpoint格式檔案的功能。

HDGF - 提供讀寫Microsoft visio格式檔案的功能。

poi 3.14 jar改進日志

add59056 - Render individual slideshow shapes;

fix59074 - ExtractorFactory should give a more helpful exception on old Excel files too old for ExcelExtractor;

add57989 - XSSFChart support for setting chart titles;

fix59030 - Prevent NPE in XWPFTableCell's getVerticalAlignment() from Prasad Babu;

fix59021 - XSSFSheetXMLHandler fails to extract content if namespace is included in qName;

fix56345 - Reject single-cell merged regions;

fix58339 - Make OFFSET() allow missing optional height and width parameters;

addgithub-27 - Handle documents with a picture-only header;

fix58996 - 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;

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

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

fix58885 - Fixed preformance regression after fixing bug 58443 when adding a merged region to an XSSFSheet;

add Raised xmlsec version to 2.0.6;

add47291 - Cannot open link correctly which insert in ppt;

add41047 - Support hyperlinks in HSLF shapes and textruns;

add58879 - Return SpreadsheetVersion from Workbook;

fix Fix NPE when calling HSLFTextRun.setHorizontalCentered();

add58633 - Set multiple cell style properties at once;

add56004 - Support for WMF rendering;

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

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

add57796 - Support hyperlink extraction when rendering slides;

fix54916 - POI does not always read all the slides in pptx files;

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

fix58067 - XWPF: don't return deleted text when document is in review-mode;

fix58618 - XWPFParagraph insertNewRun and removeRun work incorrectly for runs after hyperlink/field runs;

fix58760 - Non-standard namespace-key breaks parsing XLSX files;

fix58746 - Fix missing adjustment of formulas when sheet-ordering is changed.;

fix58616 - Try to initialize with empty password if not done before;

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

fix55030 - RichTextRun getFontName can not get chinese font name;

fix56570 - RecordType has repeat by code type 3009;

fix58159 - getHeaderText() and getFooterText() duplicate text in sheet.getTextRuns();

fix58775 - Set maximum number of data formats to avoid corrupted workbook;

add58778 - Override built-in number formats in XSSFWorkbooks;

fix58733 - New AIOOBE in getCell while iterating through a table in PPT;

fix58718 - Master styles not initialized when running multithreaded;

Apache POI 3.14免費版下載地址

遠程下載