Issues and gotchas with new POI 3.6 API (XSSF) working with Excel 2007 workbooks

Question

I just started using the new POI 3.6 http://poi.apache.org XSSF which was released in December 2009. The updated API provides support for reading and writing in the OOXML spreadsheet format (.xslx) with Java. So far I've been pretty impressed with the API and haven't really encountered any issues with it.

What issues or gotchas have you encountered working with the 3.6 API if any?

Answer 1

i got a problem with password protected excel files, it directly throws the exception. i want to tell theuser that file is password protected but at the first place itself i get the exception. This is wat i did after taking the file.

if( wbook1.isWriteProtected() ) { System.out.println(" File is Password protected "); return false; }