I cannot read an excel 2007 file

One Star

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
Community Manager

Re: I cannot read an excel 2007 file

Hello
Did you check the 'read excel2007 file format' option?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: I cannot read an excel 2007 file

Hi Shong,
thanks for your help
Yes, I check the 'read excel2007 file format' option
Best regards
Pierre
One Star

Re: I cannot read an excel 2007 file

try using jre 1.6
One Star

Re: I cannot read an excel 2007 file

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