File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes jxl.read.biff.BiffException: Unable to recognize OLE stream Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "jxl.read.biff.BiffException: Unable to recognize OLE stream" Watch "jxl.read.biff.BiffException: Unable to recognize OLE stream" New topic
Author

jxl.read.biff.BiffException: Unable to recognize OLE stream

Tom Cook
Greenhorn

Joined: Nov 24, 2012
Posts: 3
Hi Experts ,

i am trying to write a java file to read data from xlxs file. i am using POI.


Here is my code -


i am encountered with error --

please help me..
Thanks in advance.
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 3955
    
  17

Hi Tom,

Welcome to the Ranch!

What version of JExcel are you using?


Steve
Tom Cook
Greenhorn

Joined: Nov 24, 2012
Posts: 3
Thnaks Steve !!

i am using POI 3.8 and Jxl 2.6 ..
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 3955
    
  17

So there seems to be a little bit of confusion. The code you posted is not Apache POI. And it isn't JXL (JXL @ sourceforge). I assumed (incorrectly) that it was JExcel (JExcel @ TeamDev) but was wrong. You must be using JExcelAPI (JExcelApi @ sourceforge). The problem with that is it does not support the XLSX format - only the older XLS format.

JExcel and Apache POI both support XLSX format.
Tom Cook
Greenhorn

Joined: Nov 24, 2012
Posts: 3
sorry for the confusion Steve .

and yes it doesn't support for the xlxs format, but its working fine for xls format.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19544
    
  16

But you tried to open an XLSX file, that's why you got the error.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jxl.read.biff.BiffException: Unable to recognize OLE stream
 
Similar Threads
Excelsheet content reading
BIRT Reporting Tool. Getting the TEXT File
Exception raised while uploading excel file in jsp
Unable to recognize OLE stream while upload CSV
Write and Update CSV files