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