Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

I cannot read an excel 2007 file

Hello,
when i read an excel file (format : 2007 xlsx) i get this error :
Démarrage du jobaaa a 16:54 20/11/2009.
Exception in component tFileInputExcel_1
jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:268)
at csi.aaa_0_1.aaa.tFileInputExcel_1Process(aaa.java:438)
at csi.aaa_0_1.aaa.runJobInTOS(aaa.java:810)
at csi.aaa_0_1.aaa.main(aaa.java:722)
connecting to socket on port 3776
connected
disconnected
Job aaa terminé à 16:54 20/11/2009.
so, with the same file but in format xls it's ok !
I use TOS :
Version: 3.2.1
Build id: r31371-20091020-0242
Thanks for your help
Labels (3)
4 Replies
Anonymous
Not applicable

Hello
Did you check the 'read excel2007 file format' option?
Best regards
shong
_AnonymousUser
Specialist III
Specialist III
Author

Hi Shong,
thanks for your help
Yes, I check the 'read excel2007 file format' option
Best regards
Pierre
_AnonymousUser
Specialist III
Specialist III
Author

try using jre 1.6
Anonymous
Not applicable

Did this work? I am having a hard time getting Excel 2007 files to work.