Extracting data from specific Excel cells tutorial

One Star

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
Moderator

Re: Extracting data from specific Excel cells tutorial

Hi,
What's your actual result? Is it only extracting the last sheet data in your excel file?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Extracting data from specific Excel cells tutorial

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
One Star

Re: Extracting data from specific Excel cells tutorial

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