https://community.qlik.com/t5/Talend-Studio/How-to-get-Auto-Sum-at-the-end-in-a-excel-column-using-Talend/m-p/2294353#M143308 <P>Hi <BR />It is impossible to call the auto sum function with tFileOutputExcel component, you can calculate the sum value in job and insert it to specified cell, see image.</P> <P>the field of the first Y cell can be set with a context variable, its value is based on the rows are inserted into Excel file in previous subjob.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Snipaste_2020-04-27_11-24-21.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA90.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149272i188E7B947FAF7C19/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA90.png" alt="0683p000009MA90.png" /></span></SPAN><BR /><BR />Regards<BR />Shong</P> Mon, 27 Apr 2020 04:26:18 GMT Anonymous 2020-04-27T04:26:18Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Auto-Sum-at-the-end-in-a-excel-column-using-Talend/m-p/2294352#M143307 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="auto sum.PNG" style="width: 282px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9zM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138782iA542005B22825D73/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9zM.png" alt="0683p000009M9zM.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Here i Need the auto sum of column C(C1 to C7) in the cell C8, is it possible to get.</P> Sat, 16 Nov 2024 02:35:32 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Auto-Sum-at-the-end-in-a-excel-column-using-Talend/m-p/2294352#M143307 since_1995 2024-11-16T02:35:32Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Auto-Sum-at-the-end-in-a-excel-column-using-Talend/m-p/2294353#M143308 <P>Hi <BR />It is impossible to call the auto sum function with tFileOutputExcel component, you can calculate the sum value in job and insert it to specified cell, see image.</P> <P>the field of the first Y cell can be set with a context variable, its value is based on the rows are inserted into Excel file in previous subjob.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Snipaste_2020-04-27_11-24-21.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA90.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149272i188E7B947FAF7C19/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA90.png" alt="0683p000009MA90.png" /></span></SPAN><BR /><BR />Regards<BR />Shong</P> Mon, 27 Apr 2020 04:26:18 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Auto-Sum-at-the-end-in-a-excel-column-using-Talend/m-p/2294353#M143308 Anonymous 2020-04-27T04:26:18Z