Hi,
I need to write the output file in xlsm format using talend.Is this applicable in talend open studio or talend enterprise edition.
Regards,
Raakesh R
Talend Open Studio for Data Integration provides a group of Excel components that can be used to integrate with Excel file, such as tFileInputExcel, tFileOutputExcel etc. tFileOutputExcel is used to write data into a Excel file, please refer to:
https://help.talend.com/search/all?query=tFileOutputExcel&content-lang=en Shong
Talend Open Studio for Data Integration provides a group of Excel components that can be used to integrate with Excel file, such as tFileInputExcel, tFileOutputExcel etc. tFileOutputExcel is used to write data into a Excel file, please refer to: https://help.talend.com/search/all?query=tFileOutputExcel&content-lang=en Shong
Thanks shong.
Below is my req.
I write into excel 2007 (xlsx format) using tfileoutputexcel and call macro and i need to save excel in xlsm format.If it is not getting saved in xlsm format the macros will disappear.
So is there any way that i can save the excel file in xlsm format after wrting macro.
Hi
Have you tried to check the 'write excel2007 file format(xlsx) option on tFileOutputExcel component? If it does not work, you can use a custom component
tFileExcelSheetOutput developed and shared by jlolling on Talend Exchange, this component supports XLSM format. Here is a KB tutorial about how to install a custom commponet into Talend Studio.
https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en Shong
Hi Have you tried to check the 'write excel2007 file format(xlsx) option on tFileOutputExcel component? If it does not work, you can use a custom component tFileExcelSheetOutput developed and shared by jlolling on Talend Exchange, this component supports XLSM format. Here is a KB tutorial about how to install a custom commponet into Talend Studio. https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en Shong
It will support macros only if the macros already exists in the file. You cannot create macros within the Talend job. To read a file containing macros use the component tFileExcelWorkbookOpen and write your file (probably with a different name) with the component tFileExcelWorkbookSave
I too am trying to work with an excel template (.xlsm) file. I notice you mention a component for this tFileExcelWorkbookOpen but I do not see anything with that name in the palette?
