aspose 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: 4174
    
  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: 4174
    
  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: 19670
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jxl.read.biff.BiffException: Unable to recognize OLE stream