Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Tom Cook
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4181
21
IntelliJ IDE Java Python
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Tom,

Welcome to the Ranch!

What version of JExcel are you using?
 
Tom Cook
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thnaks Steve !!

i am using POI 3.8 and Jxl 2.6 ..
 
Steve Luke
Bartender
Posts: 4181
21
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20511
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
But you tried to open an XLSX file, that's why you got the error.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic