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)
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



Rilhia Solutions