Sun Country's Weblog

The Apache POI is pleased to announce the release of POI 3.7.

See the downloads page for binary and source distributions:

http://poi.apache.org/download.html

Release Notes — Apache POI — Version 3.7

Apache POI is an open source Java library for working with Microsoft
Office documents.
POI 3.7 is an incremental feature release based on the earlier 3.6 release.

The most notable changes since POI 3.6 are:
——————————————-
OOXML
* support for reading aes-encrypted/write-protected ooxml files
* support Java 1.5 in auto-generated xmlbeans for ooxml schemas

Spreadsheet (Excel)
* initial support for autofilters
* support for data validation for ooxml format
* initial support for themes for ooxml format
* added implementation for new functions: RANDBETWEEN, POISSON,
SUBTOTAL, TEXT, TRUNC
* support evaluation of indirect defined names in INDIRECT
* numerous fixes and performance optimizations in the Formula
Evaluation module
* ability to add, modify and remove series from HSSF Charts
* numerous improvements in the cell data formatter (handling more
formatting rules, better color detection, allow overriding of default
locale)
* more examples including a rich “spreadsheet to HTML” converter

Document (Word)
* initial support for the HWPF revision marks authors list
* support for border codes in HWPF
* support for processing of symbols in HWPF
* support sections in Word 6 and Word 95 files
* improved reading of auto-saved (“complex”) documents in HWPF
* improved support for manipulation of tables and paragraphs in XWPF

SlideShow (PowerPoint)
* allow editing workbooks embedded into HSLF slide shows

Text Extraction
* support for text extraction from XSLF tables
* add PublisherTextExtractor support to extractorfactory
* support attachments as embedded documents within the new
OutlookTextExtactor
* new event based XSSF text extractor (XSSFEventBasedExcelExtractor)
* make it easier to tell which content types each POIXMLTextExtractor
handles
* paragraph level as well as whole-file text extraction for word 6/95
files

* …and much much more: code cleanup, many bug fixes and performance
improvements

Contributors
————

The following people have contributed to this release by submitting bug
reports or by participating in the issue resolution process (in strict
alphabetical order).

Alexey Butchik Jeff Lavezzo Philippe Laflamme
Andrew Shirley Jens Gatze Raiko Eckstein
Andrzej Bialecki Jerry Soung Rainer Schwarze
Antoni Mylka Jonathan Holloway Ranvijay Singh
Antony Bowesman Josh Micich Rick Cameron
Antti Koskimaki Jukka Zitting Robert Kish
Attila Kiraily Kai Zimmermann Robin Salkeld
Bob Smith Kalpesh Parmar Ryan Lauck
Brendan Nolan Kamil Soltys Ryan Skow
Charlie Chang Karl Eilebrecht Samuel Yung
Chris Barlock Ken Arnold Simon Kelly
Chris Lott Liu Yan Stefan Stern
Christiaan Fluit Lon Binder Steve Wolke
Dave Fisher Martin Studer TK Gospodinov
Dave Syer Martin W. Kirst Tao Jiang
David Agnew Maxim Valyanskiy Ted Schrader
David Lewis Michael Vilensky Thomas Herre
Dmitry Sviridov Michel Boudinot Tomas Prochazka
Domenico Napoletano Nick Burch Tony Harvey
Ed Beaty Paul Spencer Trejkaz (pen name)
Fabio Ebner Payam Hekmat Tsutomu YANO
Fred Ross Peter Kutak Viveck Shastri
Grzegorz Bloch Petr Udalau Vladimir Korenev
Henry Huang Phil Dunlea William J. Coleda
Immad Naseer Phil Varner Yegor Kozlov
Jan Stette Philipp Epp Zhang Zhang

Thank you all very much! Contributions are always welcome, come join the
project.

Release Contents
—————-

This release comes in two forms:
- pre-built binaries containing compiled versions of all Apache POI
components and documentation
(poi-bin-3.7-20101029.zip or poi-bin-3.7-20101029.tar.gz)
- source archive you can build POI from (poi-src-3.7-20101029.zip or
poi-src-3.7-20101029.tar.gz)

Pre-built versions of all POI components are also available in the
central Maven repository
under Group ID “org.apache.poi” and Version “3.7″

All release artifacts are accompanied by MD5 checksums and a PGP signatures
that you can use to verify the authenticity of your download.
The public key used for the PGP signature can be found at

http://svn.apache.org/repos/asf/poi/tags/REL_3_7/KEYS

About Apache POI
———————–

Apache POI is well-known in the Java field as a library for reading and
writing Microsoft Office file formats, such as Excel, PowerPoint, Visio and
Word. Since POI 3.5, the new OOXML (Office Open XML) formats introduced
in Office 2007 have been supported.

For more information, visit http://poi.apache.org/

For the Apache POI Team
Yegor Kozlov