How to get Auto Sum at the end in a excel column using Talend

[since_1995]

Here i Need the auto sum of column C(C1 to C7) in the cell C8, is it possible to get.

[Anonymous]

Hi
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.

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.

Regards
Shong