Extracting data from specific Excel cells tutorial

[Anonymous]

Hi there,
I found a very useful tutorial on how to extract data from individual Excel cells.
Extracting data from specific Excel cells
However, the issue is I would like to iterate through all the sheets (which are in the same format) in Excel But I'm not having a luck at the moment. In tFileInputExcel component I have select 'All Sheets' but this does not seem to be processing all the sheets in the Workbook.
Thanks,
Facoda

[Anonymous]

Hi,
What's your actual result? Is it only extracting the last sheet data in your excel file?
Best regards
Sabrina

[Anonymous]

Hi xdshi,
It is extracting the first sheet. Even when I deselect 'All sheets' and specify a different sheet name than the first one it still selects the values from the first sheet.
Could it be something in the Java code given in the example?
Thanks,
Facoda

[Anonymous]

Additionally I want to say that if I put one name of the sheet in the tFileInputExcel component settings it will pick the values from that sheet but when I put more than one name of the sheet in the fFileInputExcel component settings it just picks only the values from the first sheet name in the list.
And the Java code supplied in the tutorial looks like it's just an incrementer to loop through all the cells.
Thanks,
Facoda