https://community.qlik.com/t5/Talend-Studio/How-to-iterate-through-multiple-Tabs-sheets-in-Excel-file-in/m-p/2210189#M8708 <P>I have an excel file which has multiple tabs/sheets with different name with same schema.</P> <P>I want to iterate all the excel sheet one by one. What will be the most efficient way to accomplish the&nbsp;</P> <P>requirement.&nbsp;</P> <P>Input:<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel.JPG" style="width: 227px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZst.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135727i4E2B159FB4A8704C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZst.jpg" alt="0683p000009MZst.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel_job.JPG" style="width: 525px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZg8.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137341i9E904E5978F88DDE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZg8.jpg" alt="0683p000009MZg8.jpg" /></span></SPAN></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel_Sheet Setup.JPG" style="width: 635px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZnb.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140129i2483D5FEFD680092/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZnb.jpg" alt="0683p000009MZnb.jpg" /></span></SPAN></P> Sat, 16 Nov 2024 02:11:24 GMT Tasfiahm 2024-11-16T02:11:24Z https://community.qlik.com/t5/Talend-Studio/How-to-iterate-through-multiple-Tabs-sheets-in-Excel-file-in/m-p/2210189#M8708 <P>I have an excel file which has multiple tabs/sheets with different name with same schema.</P> <P>I want to iterate all the excel sheet one by one. What will be the most efficient way to accomplish the&nbsp;</P> <P>requirement.&nbsp;</P> <P>Input:<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel.JPG" style="width: 227px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZst.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135727i4E2B159FB4A8704C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZst.jpg" alt="0683p000009MZst.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel_job.JPG" style="width: 525px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZg8.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137341i9E904E5978F88DDE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZg8.jpg" alt="0683p000009MZg8.jpg" /></span></SPAN></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Multi Excel_Sheet Setup.JPG" style="width: 635px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZnb.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140129i2483D5FEFD680092/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZnb.jpg" alt="0683p000009MZnb.jpg" /></span></SPAN></P> Sat, 16 Nov 2024 02:11:24 GMT https://community.qlik.com/t5/Talend-Studio/How-to-iterate-through-multiple-Tabs-sheets-in-Excel-file-in/m-p/2210189#M8708 Tasfiahm 2024-11-16T02:11:24Z https://community.qlik.com/t5/Talend-Studio/How-to-iterate-through-multiple-Tabs-sheets-in-Excel-file-in/m-p/2210190#M8709 <P><A href="https://community.qlik.com/s/profile/0053p000007LLAPAA4">@Tasfiahm</A>&nbsp;, 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.</P> Wed, 10 Jun 2020 05:42:38 GMT https://community.qlik.com/t5/Talend-Studio/How-to-iterate-through-multiple-Tabs-sheets-in-Excel-file-in/m-p/2210190#M8709 manodwhb 2020-06-10T05:42:38Z