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: 4167
    
  21

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: 4167
    
  21

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: 19653
    
  18

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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: jxl.read.biff.BiffException: Unable to recognize OLE stream
 
Similar Threads
BIRT Reporting Tool. Getting the TEXT File
Excelsheet content reading
Unable to recognize OLE stream while upload CSV
Write and Update CSV files
Exception raised while uploading excel file in jsp