hello Josh,

you find the attached document that I try to load (input.xls) create on
MSExcel 2003, and the result file (outout 2.xls) and read on MSExcel  2003.

I do not know how to verify the spreadsheet formats

http://www.nabble.com/file/p21746193/input.xls input.xls 
http://www.nabble.com/file/p21746193/outout%2B2%2B.xls outout+2+.xls 

Thank you for your reply.

-----------------------------------------------------

Josh Micich wrote:
> 
> Hello Hicham,
> 
> The exception that Patrick received was:
> java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
> stream, nor an OOXML stream
>   at
> org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:64)
> 
> ...which signifies that the stream is not 'OpenDocument format' (starting
> with 50 4B 03 04) nor a 'Microsoft Compound Document'/'OLE' file (starting
> with D0 CF 11 E0 A1 B1 1A E1).  As Nick mentioned above, having an
> extension
> ".xls" and being readable by Excel does not guarantee that a file is
> either
> of these two formats.  For example, the file may be plain text, html, csv,
> or even a prior BIFF (<8) version.
> 
> POI reads two spreadsheet formats:
>   BIFF8  - within a 'Microsoft Compound Document'
>   OOXML  - within an 'OpenDocument'
> 
> If you are sure that the offending document really *is* of one of these
> two
> formats, please upload it to help troubleshoot this issue further.
> 
> regards,
> Josh
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Can%27t-read-excel-2003-xls-file-tp21328806p21746193.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]

Reply via email to