Hi -
If your users are on 2007 there are now three different file formats
to consider.
(1) XLS - Excel 97-2003 - Ask your user to save to this format and
your program should continue to work.
(2) XLSX - Excel 2007 - This is the new XML based file format. POI is
added support for this after 3.2. Upgrade to POI 3.5beta5 or download
a nightly build from http://encore.torchbox.com/poi-svn-build/ - POI-
3.5-FINAL is expected within a month.
(3) XLSB - Excel 2007 binary format - This is an XML format with
binary components. There is no plan to support this in POI at this time.
Regards,
Dave
On Mar 23, 2009, at 2:25 PM, J Keller wrote:
Hi - one of my users just upgraded to Excel 207, and my program will
no
longer open her spreadsheet.
I'm using the 3.2-FINAL version. Is the 2007 XLS format supported,
and if
so, any idea what I might be doing wrong? Thanks!
-J
I get this error:
java.io.IOException: block[ 0 ] already removed
at
org.apache.poi.poifs.storage.BlockListImpl.remove(BlockListImpl.java:
97)
at
org
.apache
.poi
.poifs
.storage
.BlockAllocationTableReader
.fetchBlocks(BlockAllocationTableReader.java:190)
at
org
.apache
.poi.poifs.storage.BlockListImpl.fetchBlocks(BlockListImpl.java:130)
at
org
.apache
.poi
.poifs
.filesystem.POIFSFileSystem.processProperties(POIFSFileSystem.java:
530)
at
org
.apache
.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:176)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:
312)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:
293)
--
View this message in context:
http://www.nabble.com/Unable-to-open-Excel-2007-file-%28block--0---already-removed%29-tp22669473p22669473.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
