Eight Stars

Excel cell formula not getting calculated

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.

Tags (1)
1 REPLY
Fifteen Stars

Re: Excel cell formula not getting calculated

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

 

http://jan-lolling.de/talend/components/help/tFileExcelSheetOutput.pdf

Rilhia Solutions