topic Iterate excel sheet name in Talend Studio

Iterate excel sheet name

_AnonymousUser — Sat, 26 Apr 2014 11:20:25 GMT

hi
i have a excel file with many sheets, the sheet name like 'a..','b..','8..','8..','8..' .
i want extract data from sheet name like '8..'
what can i do? can i iterate sheets?

Re: Iterate excel sheet name

Anonymous — Mon, 28 Apr 2014 03:39:53 GMT

Hi,
Have you already checked component TalendHelpCenter:tFileInputExcel with
the sheet list option to extract data from specific sheet.
Best regards
Sabrina

Re: Iterate excel sheet name

Anonymous — Mon, 28 Apr 2014 07:46:14 GMT

Hi,
You can iterate on sheets and also can use regular expression to define name of input sheet or can have a name like "8*.*".
Whether the metadata for all the sheets is going to be same??
If your sheet names are constant, you can put it in one csv file and iterate through each sheetname to read that sheet from excel file,.. this is also possible.
Thanks
Vaibhav