Pass input parameters from an excel

Question

Hi everyone,

I'm stuck at one point where I want to pass the input parameters to a workflow from an excel sheet. So, every time I have to change the input parameters of a workflow, instead of editing the configurations in the workflow itself, I want to change the values in excel and the workflow should run with the updated parameters.

I have attached a sample workflow and a sample macro in a packaged workflow. That would make things more clear.

In case of any doubt, feel free to drop a message.

Looking forward to your suggestions.

TIA!

Sample workflow.yxzp

ssripat3 · Answer

Hello @AlterCom . Can you please share the macro you created for this requirement?

AlterCom · Answer

Hi @danilang, the issue has been resolved. Was doing a silly mistake while configuring the action tool. Thank you for the help though.

Really appreciate it :)

AlterCom · Answer

Hi @danilang,

Thanks for the fast response. The reason for using a batch macro is to run the workflow(that is saved as a Macro) for different values of dates. Thats why instead of using an excel file in innermost macro, an interface tool is used.

The final output I want is to run the innermost workflow (saved as a macro) from its last run time, (that has been logged in run log file in excel). This excel file is used in the next level workflow where the macro mentioned previously is used, it runs the macro from last run time to today's date. This has been done. No issues. But the problem arises when I try to change the input parameters of the macro from excel used in the upper level (outermost) workflow.

I hope you will be able to get the scenario.