topic Re: writing to excel xlsm format in Talend Studio

writing to excel xlsm format

_AnonymousUser — Wed, 04 Dec 2013 07:38:31 GMT

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

Re: writing to excel xlsm format

Anonymous — Wed, 04 Dec 2013 07:42:18 GMT

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

Re: writing to excel xlsm format

_AnonymousUser — Wed, 04 Dec 2013 07:51:52 GMT

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.

Re: writing to excel xlsm format

Anonymous — Wed, 04 Dec 2013 08:13:34 GMT

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

Re: writing to excel xlsm format

_AnonymousUser — Wed, 04 Dec 2013 08:19:07 GMT

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.

Re: writing to excel xlsm format

Anonymous — Wed, 04 Dec 2013 21:44:20 GMT

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

Re: writing to excel xlsm format

Anonymous — Wed, 20 May 2015 19:58:11 GMT

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?