The Apache POI project is an open source JAVA library software that reads and writes Microsoft document formats. It has now been updated to version 3.6. The new version offers less memory consumption and improved performance in handling spreadsheet formats. According to the developers, POI 3.6 can save 200% memory consumption when processing spreadsheet data compared to previous versions. The main changes are as follows:
A lightweight version of ooxml-schemas-1.0.jar. This jar file replaces the previous large ooxml-schemas-1.0.jar and Maven POMs files in the binary distribution package. This file is only 10 MB in size.
Memory improvements in the XSSF module, the new version can save 200% of memory consumption compared to the previous one.
Full support for cell annotations in XSSF.
Containing many examples, poi-examples-3.6-20091214.jar includes all examples from the poi, poi-scratchpad and poi-ooxml modules. These examples provide excellent templates for POI-based applications. Includes multiple conversions: XLSX to CSV, XLS to CSVmra, BigGridDemo, PPT to PNG, Word to Forrest and msg to txt.
-