https://community.qlik.com/t5/Talend-Studio/read-excel-sheet-headers/m-p/2332670#M101526 <P>Hello<BR />now i have an excel sheet with 50 header in row number 2<BR />Can talend read the headers automatically or do i have to enter each one manually ??<BR />and what's the step if i need to filter and count one of these columns ?<BR />Thank you<BR />Best Regards.&nbsp;</P> Wed, 15 Feb 2017 09:45:35 GMT _AnonymousUser 2017-02-15T09:45:35Z https://community.qlik.com/t5/Talend-Studio/read-excel-sheet-headers/m-p/2332670#M101526 <P>Hello<BR />now i have an excel sheet with 50 header in row number 2<BR />Can talend read the headers automatically or do i have to enter each one manually ??<BR />and what's the step if i need to filter and count one of these columns ?<BR />Thank you<BR />Best Regards.&nbsp;</P> Wed, 15 Feb 2017 09:45:35 GMT https://community.qlik.com/t5/Talend-Studio/read-excel-sheet-headers/m-p/2332670#M101526 _AnonymousUser 2017-02-15T09:45:35Z https://community.qlik.com/t5/Talend-Studio/read-excel-sheet-headers/m-p/2332671#M101527 Hi,<BR /><BLOCKQUOTE><FONT size="1"><FONT face="Verdana," helvetica="">Can talend read the headers automatically or do i have to enter each one manually ??</FONT></FONT></BLOCKQUOTE><BR /><FONT size="2"><FONT face="Verdana," sans-serif="">You can use&nbsp;Header, Footer, first column and last column to&nbsp;adjust the positions in tfileinputexcel.</FONT></FONT><BR /><FONT size="2"><FONT face="Verdana," sans-serif="">What does your expected output look like?&nbsp;Could you please elaborate your case with an example with input and expected output values?</FONT></FONT><BR /><FONT size="2"><FONT face="Verdana," sans-serif="">Best regards</FONT></FONT><BR /><FONT size="2"><FONT face="Verdana," sans-serif="">Sabrina</FONT></FONT> Thu, 16 Feb 2017 03:10:36 GMT https://community.qlik.com/t5/Talend-Studio/read-excel-sheet-headers/m-p/2332671#M101527 Anonymous 2017-02-16T03:10:36Z