https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317711#M88131 Hello <BR />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. <BR />Best regards <BR /> <BR /> shong Tue, 26 Jan 2010 09:50:06 GMT Anonymous 2010-01-26T09:50:06Z https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317710#M88130 Hi, i have to write an formula in to an Excel Cell like =dvsassetdata("Assethandle").wkn<BR />but if i open the created sheet i always see the text string =dvsassetdata("Assethandle").wkn and not the result of the formula. <BR />after i click on the cell it is an formula.<BR />But i need that is a formular when i open the sheet.<BR />Any Idea<BR />Regards Dirk Sat, 16 Nov 2024 13:35:40 GMT https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317710#M88130 Anonymous 2024-11-16T13:35:40Z https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317711#M88131 Hello <BR />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. <BR />Best regards <BR /> <BR /> shong Tue, 26 Jan 2010 09:50:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317711#M88131 Anonymous 2010-01-26T09:50:06Z https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317712#M88132 Hi shong, <BR />thanks for answer but, <BR />DVSASSETDATA is an additional Excelfunction of our Datawarehouse Excel Plugin. <BR />Today i search a little and i found the jxl.write provides Excel Formula handling !!! <BR />But how i can use it ? <BR />Regards Dirk Tue, 26 Jan 2010 15:38:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-write-an-Excel-Formula-with-tFileOutputExcel/m-p/2317712#M88132 Anonymous 2010-01-26T15:38:47Z