One Star

writing to excel xlsm format

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
6 REPLIES
Community Manager

Re: writing to excel xlsm format

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 | Data Agility for Modern Business
One Star

Re: writing to excel xlsm format

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.
Community Manager

Re: writing to excel xlsm format

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: writing to excel xlsm format

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

Thx shong.will try it out.
Seventeen Stars

Re: writing to excel xlsm format

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

Re: writing to excel xlsm format

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?