error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

[SachinD]

I am developing one Job in which I am facing some issue in below segment for component tFileInputExcel

tfilelist --> iterate -- > tFileInputDelimited --> tmap --> tmssqloutput --> tFileInputExcel (another file) --> Tmap --> tmssqloutput

I am getting error for tFileInputExcel (another XLSX file)
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Can only iterate over an array or an instance of java.lang.Iterable


but i hv observed when i uncheck
Read excel2007 fileformat (xlsx) and use xls file it works fine

[cterenzi]

What type of connection do you have between tMSSqlOutput and tFileInputExcel?

[vapukov]

What connection between - tmssqloutput --> tFileInputExcel (another file)?

tfilelist --> iterate -- > tFileInputDelimited --> tmap --> tmssqloutput --> OnComponentOk (??) --> tFileInputExcel (another file) --> Tmap --> tmssqloutput

better if You attach picture of You Job (with settings)

[SachinD]

[SachinD]

I was thinking, here is some issue with job/ component configuration.

But I observed that even if I just try to create METADATA for any .xlsx file, its gives me same error 

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Can only iterate over an array or an instance of java.lang.Iterable

screenshot attached

I am using "Jaspersoft ETL" enterprise edition

Version: 5.6.2
Build id: V5.6.2_20150508_1414

[SachinD]

I am getting same error even while creating metadata for .xlsx, please check latest sceenhost

[vapukov]

I do not have 5.6 for now, all migrated 

oldest available version - 6.1

the problem could be and in Jasper (Talend) and with Excel (office)

if You want - You can send .xlsx example I can test with 6.1 - 6.4

[SachinD · Accepted solution]

nothing specific to particular .xlsx file, it was giving error for all xlsx files.

So, finally solution that worked for me is,

I exported that job to another machine, which exactly has same version Version: 5.6.2
and it worked absolutely fine without any issues.

I wasted my 2 days though.

Thanks All for helping.

[cterenzi]

Thanks for posting your solution!