How to write an Excel Formula with tFileOutputExcel

One Star

How to write an Excel Formula with tFileOutputExcel

Hi, i have to write an formula in to an Excel Cell like =dvsassetdata("Assethandle").wkn
but if i open the created sheet i always see the text string =dvsassetdata("Assethandle").wkn and not the result of the formula.
after i click on the cell it is an formula.
But i need that is a formular when i open the sheet.
Any Idea
Regards Dirk
Community Manager

Re: How to write an Excel Formula with tFileOutputExcel

Hello
Talend only write the result to excel file without populating any formula of Excel. What's the purpose of your furmula "dvsassetdata"? You can using the Talend function to get the same result and output it to Excel.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to write an Excel Formula with tFileOutputExcel

Hi shong,
thanks for answer but,
DVSASSETDATA is an additional Excelfunction of our Datawarehouse Excel Plugin.
Today i search a little and i found the jxl.write provides Excel Formula handling !!!
But how i can use it ?
Regards Dirk