wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 4164
    
  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: 4164
    
  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: 19649
    
  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
 
Similar Threads
BIRT Reporting Tool. Getting the TEXT File
Unable to recognize OLE stream while upload CSV
Write and Update CSV files
Excelsheet content reading
Exception raised while uploading excel file in jsp