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.
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!
