I would have file Output in excel with macro : xlsm but Talend can't write in xlsm with fileOutputExcel.
So, i try with :
But, when i try open file xlsm, i have this error :
Impossible to open the file because its format or its extension is not valid. Verify that the file is not damaged and that its extension corresponds well to the format of the file.
So, i verify if it is "xlsm" and yes.
I don't know why i can't open this file.
In the meantime, I work with a file xlsx with macro in another file xlsm.
Thnaks in advance
Here exists a new feature jira issue:https://jira.talendforge.org/browse/TDI-25011.
Join us live for a sneak peek!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.