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