Apache POI

Software Screenshot:
Apache POI
Software Details:
Version: 3.13 updated
Upload Date: 6 Mar 16
Distribution Type: Freeware
Downloads: 122

Rating: 2.5/5 (Total Votes: 2)

Apache POI was designed to work with the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2).

Using POI, developers can read and write MS Excel files, MS Word files, MS PowerPoint files and MS Outlook messages using Java.

The project is mainly used in crawling the Web, data mining and text extraction from various applications.

Apache POI is also organized as components, so developers can only use the parts they need in their projects without loading thousands of source code lines without ever using them.

All components are well documented and have been battle tested in many production-use apps.

What is new in this release:

  • On supported XML parser versions (Xerces or JVM built-in, XMLBeans 2.6), enforce sensible limits on entity expansion in OOXML files, and ensure that subsequent normal files still pass fine.
  • Tidy up the OPC SAX setup code with a new common Helper, preventing external entity expansion.

What is new in version 3.12:

  • On supported XML parser versions (Xerces or JVM built-in, XMLBeans 2.6), enforce sensible limits on entity expansion in OOXML files, and ensure that subsequent normal files still pass fine.
  • Tidy up the OPC SAX setup code with a new common Helper, preventing external entity expansion.

What is new in version 3.11 / 3.12-beta1:

  • On supported XML parser versions (Xerces or JVM built-in, XMLBeans 2.6), enforce sensible limits on entity expansion in OOXML files, and ensure that subsequent normal files still pass fine.
  • Tidy up the OPC SAX setup code with a new common Helper, preventing external entity expansion.

What is new in version 3.11:

  • On supported XML parser versions (Xerces or JVM built-in, XMLBeans 2.6), enforce sensible limits on entity expansion in OOXML files, and ensure that subsequent normal files still pass fine.
  • Tidy up the OPC SAX setup code with a new common Helper, preventing external entity expansion.

What is new in version 3.9:

  • Avoid NPE in PPT2PNG
  • Replace System.err info messages with a POILogger
  • Improved performance of DataFormatter with Fractions
  • Ensure that CTHMerge and CTTcBorders go to poi-ooxml-schemas JAR
  • Fixed extracting text from table cells in HSLF
  • Added support for drop-down lists in doc to html convertion
  • Added workaround for files with broken CHP SPRMs

What is new in version 3.8:

  • NPOIFS: NIO driven API to read OLE2 filesystems with low memory footprint.
  • SXSSF: a low-memory footprint API built on top of XSSF that can be used when very large spreadsheets have to be produced, and heap space is limited.
  • Ant tasks for running POI against a workbook.
  • Supported evaluation of new Excel formulas: IRR,NPV,MROUND,VAR,VARP,CLEAN,CHAR,ADDRESS,HOUR,MINUTE,SECOND,RATE,WORKDAY,NETWORKDAYS,SUMIFS,RANK
  • XSLF usermodel API: POI's implementation of the PowerPoint 2007 OOXML (.xlsx) file format. XSLF provides a rich usermodel API and a PPTX2PNG utility to export slides to images.
  • WordToFO, WordToHtml and WordToText converters: utilities to export MS Word .doc files into XSL-FO, html and text files. Output from WordToFO can be used to convert .doc files to pdf using Apache FOP.

What is new in version 3.8-beta5:

  • Deprecated XSSFWorkbook(String path) constructor because it does not close underlying .zip file.
  • Fixed refcount of Fill pictures in HSLF.
  • Support compression of temp files in SXSSF.
  • Support cloning sheets with drawings in XSSF.
  • Support XWPF smart tags text in Paragraphs.
  • More XSSF new-line in formula support.
  • EntryUtils.copyNodes(POFS,POIFS) now uses FilteringDirectoryNode, so can exclude from copying nodes not just directly under the root.
  • Helper FilteringDirectoryNode, which wraps a DirectoryEntry and allows certain parts to be ignored.
  • Fixed inserting multiple pictures in XSLF.

What is new in version 3.8-beta2:

  • Featured are significant performance improvements and numerous bug fixes.

What is new in version 3.8-beta1:

  • Ant tasks for running POI against a workbook.
  • Correct XBAT chaining explanation in /poifs/fileformat.html.
  • Support for getting the tables associated with a XSSFSheet.
  • More XSSFColor updates for ARGB vs RGB.
  • Use stax:stax-api instead of org.apache.geronimo.specs:geronimo-stax-api_1.0_spec.
  • Fix XSSFColor to fetch the RGB values of old-style indexed colors.

What is new in version 3.7:

  • Avoid NPE in ListLevel.getNumberText() when numberText is null.
  • Marked commons-logging and log4j as optional dependencies in POI poms.
  • Allow overridden built-in formats in XSSFCellStyle.
  • Support for BorderCode in HWPF.
  • Support for processing of symbols in HWPF.
  • Support for retrieving pictures from HSSF workbooks.
  • Avoid IllegalStateException when creating Data validation in sheet with macro.
  • Improved rounding in MOD.
  • addGenerate SHA1 hashes of distribution files, alongside existing MD5 ones.

What is new in version 3.6:

  • Release system resources when using Picture.resize().
  • Relaxed validation check in RecalcIdRecord.
  • Added a method to set arabic mode in HSSFSheet.
  • Added Ant target to compile scratchpad examples.
  • Fixed XSSFSheet autoSizeColumn() to tolerate empty RichTextString.

Similar Software

Eskimo
Eskimo

1 Oct 15

PyFacebook
PyFacebook

13 May 15

Landing.js
Landing.js

12 May 15

Python-wowapi
Python-wowapi

20 Jul 15

Other Software of Developer Apache Software Foundation

Apache Pig
Apache Pig

20 Jul 15

Apache CXF
Apache CXF

9 Feb 16

Apache Marmotta
Apache Marmotta

1 Mar 15

Apache Hive
Apache Hive

21 Jul 15

Comments to Apache POI

Comments not found
Add Comment
Turn on images!