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 ]
· 51678 - Extracting text from Bug51524.zip is slow(poi-developers)
· 51671 - HWPFDocument.write based on NPOIFSFileSystem throws a NullPointerException(poi-developers)
· support for tables and hyperlinks in XSLF(poi-developers)
· 51535 - correct signed vs unsigned short reading in NDocumentInputStream(poi-developers)
· 51634 - support SXSSF streaming from templates(poi-developers)
· initial support for XSLF usermodel API(poi-developers)
· 51187 - fixed OPCPackage to correctly handle self references(poi-developers)
· 51635 - Improved performance of XSSFSheet#write(poi-developers)
· 47731 - Word Extractor considers text copied from some website as an embedded object(poi-developers)
· Add Word-to-Text converter and use it as replacement for WordExtractor(poi-developers)
· 51604 - replace text fails for doc ( poi 3.8 beta release from download site )(poi-developers)
· Fixed incorrect encoding of non-breaking space (0xA0) in SXSSF(poi-developers)
· Support for conditional formatting in XSSF(poi-develo...