The Apache POI consists of APIs for manipulating various file formats based upon Microsoft's OLE 2 Compound Document format, and Office OpenXML format, using pure Java. In short, you can read and write MS Excel files using Java.

In addition, you can read and write MS Word and MS PowerPoint files using Java. POI is your Java Excel solution (for Excel 97-2007). However, we have a complete API for porting other OLE 2 Compound Document formats and welcome others to participate.

OLE 2 Compound Document Format based files include most Microsoft Office files such as XLS and DOC as well as MFC serialization API based file formats.

Office OpenXML Format based files include the new (2007+) xml based file formats, including Microsoft office files such as XLSX, DOCX and PPTX.

What's New in This Release: [ read full changelog ]

· 47089 - Fixed XSSFWorkbook.createSheet to properly increment sheetId(POI-DEVELOPERS)
· 46568 - Fixed XSLFPowerPointExtractor to properly process line breaks(POI-DEVELOPERS)
· 39056 - Fixed POIFSFileSystem to set CLSID of root when constructing instances from InputStream(POI-DEVELOPERS)
· 47054 - Fixed cloneStyleFrom to avoid exception when cloning styles of the same family(POI-DEVELOPERS)
· 46186 - Fixed Sheet to read GutsRecord in the Sheet(RecordStream rs)(POI-DEVELOPERS)
· 46714 - Automatically call sheet.setAlternativeExpression when sheet.setRowSumsBelow is called (POI-DEVELOPERS)
· 46279 - Allow 255 arguments for excel functions in XSSF (POI-DEVELOPERS)
· 47028 - Fixed XSSFCell to preserve cell style when cell value is set to blank(POI-DEVELOPERS)
· 47026 - Avoid NPE in XSSFCell.setCellType() when workbook does not have SST(POI-DEVELOPERS)
· 46987 - Allow RecordFactory to handle non-zero padding at the end of the workbook stream(POI-DEVELOPERS)
· 47034 - Fix reading the name of...