topic Re: Calling Excel Macro from Talend Job in Talend Studio

Calling Excel Macro from Talend Job

Anonymous — Sat, 16 Nov 2024 13:49:13 GMT

Dears,
Is it possible to call excel macro from a talend job. Can you please help me with the screen shot. thanks in advance.
Regards,
Ram

Re: Calling Excel Macro from Talend Job

Anonymous — Mon, 17 Aug 2009 10:48:51 GMT

You need custom code for that ( java, perl or command line call ).
Investigate excel COM model.

Re: Calling Excel Macro from Talend Job

Anonymous — Mon, 17 Aug 2009 10:52:55 GMT

Hi,
The excel is an all in one software. it can have data, screen, report and processing logic and all in one software. The excel is one of the good software for developing single-user application.
Talend provides facility to use Excel as input and output data file and guess it does not provide facility to execute the logic defined inside an excel in a form a macro.
Thanks and Regards,
Pravu Mishra.

Re: Calling Excel Macro from Talend Job

Anonymous — Tue, 18 Aug 2009 13:13:26 GMT

I repeat not natively in Talend, but you can run a quick external script in Talend ( that calls COM methods of excel ), for example you can call via command line component in Talend a powershell script like:
--------
$excel = new-object -comobject excel.application
$workbook = $excel.workbooks.open($myfile)
$excel.Run("MyDefinedMacro")
$workbook.save()
$workbook.close()
$excel.quit()
-------
would do the trick.
hope it helps
bye!