I am able to paste the excel formula in last column thru talend, after the successful transformation when i open the excel the formula is not showing the result. But, it was just displaying the formula i have hard-coded in talend tMap component. Please suggest.
You cannot write formulas using the default Talend Excel components. You will need to use a Talend Exchange Component like the tFileExcelSheetOutput written by @jlolling