topic Extracting data from specific Excel cells tutorial in Talend Studio

Extracting data from specific Excel cells tutorial

Anonymous — Tue, 03 Mar 2015 17:22:52 GMT

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

Re: Extracting data from specific Excel cells tutorial

Anonymous — Wed, 04 Mar 2015 06:56:08 GMT

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

Re: Extracting data from specific Excel cells tutorial

Anonymous — Wed, 04 Mar 2015 13:47:07 GMT

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

Re: Extracting data from specific Excel cells tutorial

Anonymous — Wed, 04 Mar 2015 14:33:35 GMT

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