Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Tasfiahm
Creator
Creator

How to iterate through multiple Tabs/sheets in Excel file in Talend

I have an excel file which has multiple tabs/sheets with different name with same schema.

I want to iterate all the excel sheet one by one. What will be the most efficient way to accomplish the 

requirement. 

Input:0683p000009MZst.jpg0683p000009MZg8.jpg

0683p000009MZnb.jpg

Labels (3)
1 Reply
manodwhb
Creator III
Creator III

@Tasfiahm , first you should maintain a table or a file to all have sheet name and read it and iterate using tflowtoiterate,and then pass to global variable of tflowtoiterate to tfileinputexcel.