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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.