Can iRPA create a blank excel workbook by a Z program call?

[former_member754976]

Hi Experts,

In our current SAP system (ECC), a Z program running as a background job generates an excel file.

As business volume increase, this job will soon be required to run in parallel of half and half, that generates two excel files (each file contains half of the expected full results).

Users prefer an automatic way to combine these 2 excel files.

I'm thinking to use iRPA with below steps --

1. Wait the Z program to start. At the beginning of z program run, create a blank workbook and save it.
2. once any of result excel files are ready (by the parallel z program job1 and job2), open it (excel1 or excel2); and open the blank workbook (book1).
3. from each excel file (excel1 or excel2), move/copy the result sheet to the end of book1.
4. close the excel (excel1 or excel2) and book1

My question is on step 1 -- can it be done by iRPA (initiated by a SAP Z program step, the time is not fixed)?

Thank you,

Hans

[Janarthanan]

Hi, You can build small automation to create a blank excel file using Add and Save Excel Workbook.

Regards

Janarthanan

[former_member754976]

Hi Janarthanan,

Can share your thoughts on how to start the "create Excel file" iRPA?

Note we should not run it manually in attended mode. Just wondering if it could be triggered by an API which is integrated with a SAP ABAP program?

Thank you,

Hans

[former_member754976]

Just to follow up on API trigger -- what data is expected by iRPA, that the external event trigger should pass over to the BOT? should the data sent directly to the desktop agent or to cloud factory?