topic Re: How to read with multiple sheets, multi Excel file some cells in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-read-with-multiple-sheets-multi-Excel-file-some-cells/m-p/2248696#M33471 <P><SPAN>That's OK, I solved my difficulty by adding 1 tFileInputExcel and a 1 tJavaRow per Excel sheet</SPAN></P> <P>&nbsp;</P> <P><SPAN>Thanks<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture_Talend4.JPG" style="width: 933px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0P4.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149544iD00D623FA4516B9F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0P4.jpg" alt="0683p000009M0P4.jpg" /></span></SPAN></SPAN></P> Mon, 08 Oct 2018 15:29:12 GMT Anonymous 2018-10-08T15:29:12Z How to read with multiple sheets, multi Excel file some cells https://community.qlik.com/t5/Talend-Studio/How-to-read-with-multiple-sheets-multi-Excel-file-some-cells/m-p/2248695#M33470 <P>Hi,</P> <P>&nbsp;</P> <P>I want to read from multi Excel file, some cells. So it's work well with TJavaRow and Context.</P> <P>My problem is when cells are on multi sheets ; How can I iterate to each sheet&nbsp; ?<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture_Talend3.JPG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0Ok.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140821iC9F73B35B53E3088/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0Ok.jpg" alt="0683p000009M0Ok.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture_Talend2.JPG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzXD.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138360i196D43F0C39AFD74/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzXD.jpg" alt="0683p000009LzXD.jpg" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture_Talend1.JPG" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0EJ.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150742i2363300FBEA9DB5B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0EJ.jpg" alt="0683p000009M0EJ.jpg" /></span></SPAN>?</P> <P>&nbsp;</P> <P>Thanks</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 08 Oct 2018 13:04:39 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-with-multiple-sheets-multi-Excel-file-some-cells/m-p/2248695#M33470 Anonymous 2018-10-08T13:04:39Z Re: How to read with multiple sheets, multi Excel file some cells https://community.qlik.com/t5/Talend-Studio/How-to-read-with-multiple-sheets-multi-Excel-file-some-cells/m-p/2248696#M33471 <P><SPAN>That's OK, I solved my difficulty by adding 1 tFileInputExcel and a 1 tJavaRow per Excel sheet</SPAN></P> <P>&nbsp;</P> <P><SPAN>Thanks<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture_Talend4.JPG" style="width: 933px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0P4.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149544iD00D623FA4516B9F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0P4.jpg" alt="0683p000009M0P4.jpg" /></span></SPAN></SPAN></P> Mon, 08 Oct 2018 15:29:12 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-with-multiple-sheets-multi-Excel-file-some-cells/m-p/2248696#M33471 Anonymous 2018-10-08T15:29:12Z