topic Re: I cannot read an excel 2007 file in Talend Studio

I cannot read an excel 2007 file

_AnonymousUser — Sat, 16 Nov 2024 13:40:26 GMT

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

Re: I cannot read an excel 2007 file

Anonymous — Mon, 23 Nov 2009 08:28:59 GMT

Hello
Did you check the 'read excel2007 file format' option?
Best regards
shong

Re: I cannot read an excel 2007 file

_AnonymousUser — Mon, 23 Nov 2009 08:59:27 GMT

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

Re: I cannot read an excel 2007 file

_AnonymousUser — Thu, 07 Oct 2010 09:37:45 GMT

try using jre 1.6

Re: I cannot read an excel 2007 file

Anonymous — Wed, 23 Feb 2011 17:31:23 GMT

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