Extracting data from specific Excel cells tutorial
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
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
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
