poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Fisher <dfis...@jmlafferty.com>
Subject Re: Unable to open Excel 2007 file (block[ 0 ] already removed)
Date Tue, 24 Mar 2009 16:04:36 GMT
Paul,

XLSX is supported by XSSF while XLS is supported by HSSF. In POI-3.5  
there is a common "SS" model that combines the two. You will need to  
use that to support both formats.

Please see this page: http://poi.apache.org/spreadsheet/converting.html

Regards,
Dave

On Mar 24, 2009, at 8:57 AM, J Keller wrote:

>
> I upgraded to Excel 2007, and opened my 2003 XLS file, and saved it  
> as a 2007
> XLSX file.
>
> I now get this error:
>
> org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied  
> data
> appears to be in the Office 2007+ XML. POI only supports OLE2 Office
> documents
> 	at
> org 
> .apache 
> .poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java: 
> 108)
> 	at
> org 
> .apache 
> .poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:151)
> 	at  
> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java: 
> 312)
> 	at  
> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java: 
> 293)
>
>
> Dave Fisher-6 wrote:
>>
>> (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.
>>
>
> -- 
> View this message in context: http://www.nabble.com/Unable-to-open-Excel-2007-file-%28block--0---already-removed%29-tp22669473p22683539.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message