One Star

Iterate excel sheet name

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?
2 REPLIES
Moderator

Re: Iterate excel sheet name

Hi,
Have you already checked component TalendHelpCenter:tFileInputExcel with
the sheet list option to extract data from specific sheet.
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.
Four Stars

Re: Iterate excel sheet name

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