February 22, 2009

22 February 2009 - Apache POI 3.5 beta 5 now available

The Apache POI team is pleased to announce the availability of Apache POI 3.5
beta 5, our latest beta including OOXML (Office Open XML) support.

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. With POI 3.5, it supports the new OOXML (Office Open XML) formats
introduced in Office 2007. See http://poi.apache.org/ for more details

The status of this release is a beta, meaning that we encourage users to
try it out.
If you find any bugs, please report them to the POI bug database or to
the poi-dev mailing list.

The most important changes since the previous release (3.5-beta4) are:
* Resolved licensing issues around the HDGF resource file,
chunks_parse_cmds.tbl (see bugzilla #46361).
* Openxml4J codebase is now a part of Apache POI
* Improvements in formula evaluation, support for more built-in functions
* Better handling of shifted rows
* Over 40 bug fixes and improvements.

A full list of changes is available in the change log:
http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror:
http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under
Group ID "org.apache.poi" and Version "3.5-beta5".

----

-- Apache POI Project

Posted by Tetsuya Kitahata at 08:14 AM

July 18, 2008

18 July 2008 - Apache POI 3.5.1 beta Now Available

The Apache POI team is pleased to announce the availability of Apache POI 3.5.1 beta 1, our first release including OOXML (Office Open XML) support.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word. With POI 3.5, it also support the new OOXML formats introduced in Office 2007. See http://poi.apache.org/ for more details

----

Release Highlights:

  • POI-SS - Java API To Access Microsoft Excel Format Files
    • This common interface allows access to HSSF (binary file format, .xls) and XSSF (ooxml file format, .xlsx) in the same way
  • Very similar to HSSF usermodel, allowing easy translation of old code support to the new format
  • All of HSSF should support this interface
  • Partial implementation of XSSF for this interface
  • POI-XSSF - Java API To Access Microsoft Excel 2007 OOXML Format Files
    • partial implementation of high level interface
    • text extraction supported
    • low level, low memory parsing supported
  • POI-XSLF - Java API To Access Microsoft PowerPoint 2007 OOXML Format Files
    • text extraction supported
  • POI-XWPF - Java API To Access Microsoft Word 2007 OOXML File Formats
    • text extraction supported


In addition, all fixes from POI 3.1 FINAL, and from just after, are included. For full changelog details, and documentation, please see /docs/ in the distribution. The documentation on the website reflects the state of work on POI 3.1.1.


The source and binaries can be downloaded from your local mirror: http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under Group ID "org.apache.poi" and Version "3.5.1-beta1". Note that the ooxml support is not available via Maven, as the dependencies are not packaged.

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 08:23 PM

July 01, 2008

01 July 2008 - Apache POI 3.1-Final Releaesd

The Apache POI team is pleased to announce the availability of Apache POI 3.1-FINAL.

Apache POI is well-known in the Java field as a library for reading and
writing OLE2 office file formats, such as Excel, PowerPoint, Visio and
Word. See http://poi.apache.org

Release Highlights:

POI-HSSF - Java API To Access Microsoft Excel Format Files
* Major improvements in formula evaluation
* Support for conditional formatting
* Support for Excel hyperlinks
* Handling of embedded OLE2 documents
* Support for getting excel cell comments when extracting text
* Support for specifying a policy to HSSF on missing / blank cells when fetching

POI-HSLF - Java API To Access Microsoft PowerPoint Format Files
* Support for getting embedded sounds
* Support for getting embedded OLE objects
* Support for Tables
* Improved text extraction
* Export PowerPoint slides into image
* Java2D Graphics driver

POI-HWPF - Java API To Access Microsoft Word Format Files
* Handling of embedded OLE2 documents
* Support for extracting Escher images from HWPF files
* Improved Range.replaceText()

About 100 other fixes and improvements. A full list of changes is available in the change log:
http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror:
http://www.apache.org/dyn/closer.cgi/poi/release/

The release is also available from the central Maven repository under
Group ID "org.apache.poi" and Version "3.1-FINAL".

Apache POI Team

Posted by Tetsuya Kitahata at 01:31 AM

May 28, 2008

28 May 2008 - Apache POI 3.1-beta2 Now Available

The Apache POI team is pleased to announce the release of 3.1 BETA2 which is one of the final steps before 3.1 FINAL.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word.

The status of this release is a beta, meaning that we encourage users to try it out. If you find any bugs, please report them to the POI bug database or to the poi-dev mailing list.

Summary of changes since 3.1-beta1:

  • fix44306 - fixed reading/writing of AttrPtg(type=choose) and method toFormulaString() for CHOOSE formulas(POI-DEVELOPERS)
  • fix24207 - added HSSFName.isDeleted() to check if the name points to cell that no longer exists(POI-DEVELOPERS)
  • fix40414 - fixed selected/active sheet after removing sheet from workbook(POI-DEVELOPERS)
  • fix44523 - fixed workbook sheet selection and focus(POI-DEVELOPERS)
  • fix45000 - Fixed NPE in ListLevel when numberText is null(POI-DEVELOPERS)
  • fix44985 - Properly update TextSpecInfoAtom when the parent text is changed(POI-DEVELOPERS)
  • fix41187 - fixed HSSFSheet to properly read xls files without ROW records(POI-DEVELOPERS)
  • fix44950 - fixed HSSFFormulaEvaluator.evaluateInCell() and Area3DEval.getValue() also added validation for number of elements in AreaEvals(POI-DEVELOPERS)
  • fix42570 - fixed LabelRecord to use empty string instead of null when the length is zero.(POI-DEVELOPERS)
  • fix42564 - fixed ArrayPtg to use ConstantValueParser. Fixed a few other ArrayPtg encoding issues.(POI-DEVELOPERS)
  • fixFollow-on from 28754 - StringPtg.toFormulaString() should escape double quotes(POI-DEVELOPERS)
  • fix44929 - Improved error handling in HSSFWorkbook when attempting to read a BIFF5 file(POI-DEVELOPERS)
  • fix44675 - Parameter operand classes (function metadata) required to encode SUM() etc properly. Added parse validation for number of parameters(POI-DEVELOPERS)
  • fix44921 - allow Ptg.writeBytes() to be called on relative ref Ptgs (RefN* and AreaN*)(POI-DEVELOPERS)
  • fix44914 - Fix/suppress warning message "WARN. Unread n bytes of record 0xNN"(POI-DEVELOPERS)
  • fix44892 - made HSSFWorkbook.getSheet(String) case insensitive(POI-DEVELOPERS)
  • fix44886 - Correctly process PICT metafile in EscherMetafileBlip(POI-DEVELOPERS)
  • fix44893 - Take into account indentation in HSSFSheet.autoSizeColumn(POI-DEVELOPERS)

A full list of changes is available in the change log: http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror: http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under Group ID "org.apache.poi" and Version "3.1-beta2".

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 01:55 AM

April 30, 2008

30 April 2008 - Apache POI 3.1-beta1 Now Available

The POI team is pleased to announce the release of 3.1 BETA1 which is one of the final steps before 3.1 FINAL.

Apache POI is well-known in the Java field as a library for reading and
writing OLE2 office file formats, such as Excel, PowerPoint, Visio and
Word.

The status of this release is a beta, meaning that we encourage users to try it out.
If you find any bugs, please report them to the POI bug database or to
the poi-dev mailing list.

The release contains a mixture of new features and bug fixes, compared
to 3.0.2. The most important changes are:
- Major improvements in Excel formula evaluation
- Support for conditional formatting in Excel
- Handling of embedded OLE2 documents in Excel and PowerPoint
- Major improvements in the API for PowerPoint (support for Tables,
better handling of text properties, PPT Graphics2D driver)
- Export PowerPoint slides into image

A full list of changes is available in the change log:
http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror:
http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under
Group ID "org.apache.poi" and Version "3.1-beta1".

Posted by Tetsuya Kitahata at 02:26 AM

March 25, 2008

25 March 2008 - Microsoft and Sourcesense Partner to Contribute to Open Source, Apache POI

Microsoft Corp. (Nasdaq "MSFT") and Sourcesense, a leading European open source systems integration consultancy, announced that the two companies will collaborate on the strategy, development and deployment of open source solutions for the Microsoft Office product suite. See the Press-Release for more details.

Related: Apache POI - http://poi.apache.org/

Posted by Tetsuya Kitahata at 03:17 PM

February 07, 2008

07 February 2008 - Apache POI 3.0.2 Released

The Apache POI team is pleased to announce the release of POI 3.0.2.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word.

There have been many important bug fixes since the 3.0.1 release and a lot of new features.

A full list of changes is available in the change log: http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror: http://www.apache.org/dyn/closer.cgi/poi/release/

The release is also available from the central Maven repository under Group ID "org.apache.poi" and Version "3.0.2-FINAL".

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 08:55 AM

January 14, 2008

14 January 2008 - Apache POI 3.0.2 BETA2 Now Available

The Apache POI developers are pleased to announce the release of Apache POI 3.0.2 BETA2 which is one of the final steps before the 3.0.2 FINAL.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word.

The release contains a mixture of new features and bug fixes, compared to 3.0.1. A full list of changes is available in the change log: http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror: http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under Group ID "org.apache.poi".

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 11:37 AM

December 07, 2007

07 December 2007 - Apache POI 3.0.2 BETA1 Now Available

The Apache POI developers are pleased to announce the release of Apache POI 3.0.2 BETA1 which is one of the final steps before the 3.0.2 FINAL.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word.

The release contains a mixture of new features and bug fixes, compared to 3.0.1. A full list of changes is available in the change log: http://poi.apache.org/changes.html

The source and binaries can be downloaded from your local mirror: http://www.apache.org/dyn/closer.cgi/poi/dev/

The release is also available from the central Maven repository under Group ID "org.apache.poi".

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 02:37 PM

July 09, 2007

09 July 2007 - Apache POI 3.0.1 released

The Apache POI Team is pleased to announce the immediate availability of Apache POI 3.0.1 (formerly known as Apache Jakarta POI). This is our first release since our TLP (Top Level Project) graduation from Apache Jakarta, and we would like to thank all those who helped it happen.

Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word.

Besides a number of bug fixes, this release offers a range of new features including:

  • Improvements to date cell detection, via isADateFormat
  • "missing record aware" HSSF event model
  • Lots of HSLF (PowerPoint) updates
  • HDGF - basic, read only support for Visio Files

A full changelog is available at: http://poi.apache.org/changes.html

Apache POI 3.0.1 is downloadable from the apache website and mirrored sites: http://www.apache.org/dyn/closer.cgi/poi/release/

----

-- The Apache POI Team

Posted by Tetsuya Kitahata at 07:12 PM

June 08, 2007

08 June 2007 - Apache POI TLP (Top Level Project) move

Apache POI has moved to a TLP at its new address, http://poi.apache.org.

Apache POI provides set of APIs for creating, reading, and writing files based upon the OLE 2 Compound Document Format using only Java.

Posted by Tetsuya Kitahata at 03:30 PM