tFileRowCount cannot couny a excel 2010 file(xlsx)

Anonymous — Sat, 16 Nov 2024 12:43:58 GMT

Hi,
I am having issues with tFileRowCount (not able to count a 2010 excel file ..has any one faces this issue...If so can you share how you fixed it.
But if i save it as excel 2007 format ,,,no issues
Talend integration Studio 4.1.2.r53616.
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 talend_dev.ops_whirpool_benefits_0_1.ops_whirpool_benefits.tFileInputExcel_1Process(ops_whirpool_benefits.java:4613)
at talend_dev.ops_whirpool_benefits_0_1.ops_whirpool_benefits.ops_sweepfiles_1_tFileList_2Process(ops_whirpool_benefits.java:2069)
at talend_dev.ops_whirpool_benefits_0_1.ops_whirpool_benefits.ops_sweepfiles_1_tFileList_1Process(ops_whirpool_benefits.java:1449)
at talend_dev.ops_whirpool_benefits_0_1.ops_whirpool_benefits.runJobInTOS(ops_whirpool_benefits.java:31801)
at talend_dev.ops_whirpool_benefits_0_1.ops_whirpool_benefits.main(ops_whirpool_benefits.java:31533)
disconnected
Job ops_whirpool_benefits ended at 15:59 18/08/2011.
Thanks
Mohan

topic tFileRowCount cannot couny a excel 2010 file(xlsx) in Talend Studio

tFileRowCount cannot couny a excel 2010 file(xlsx)