UiPath job trigger from MS Excel

Help Something Else
, , , ,
1

Hi everyone,

We are trying to design a solution where a business user can trigger a UiPath job directly from Microsoft Excel using an Excel add-in or extension.

The requirement is as follows:

  • The user works on an Excel worksheet and fills in data.
  • From Excel, the user should be able to click a button (via an add-in or extension).
  • A pop-up dialog should appear listing available UiPath jobs.
  • The user selects the job they want to run.
  • The selected UiPath job is triggered, and the worksheet data is passed as input to the job.

We would like to avoid using UiPath Studio or Orchestrator UI directly, and keep the entire experience within Excel as much as possible.

Has anyone implemented something similar using:

  • UiPath Integration Service
  • Orchestrator APIs
  • Microsoft Office Add-ins / Office Scripts
  • Or any UiPath-provided Excel extensions?

Any architecture suggestions, best practices, or reference implementations would be greatly appreciated.

Thanks in advance!

2

@Sundararaman_S1

I haven’t implemented it but use VBA and consume the Orchestrator APIs should fulfill your requirement.

3

Hi @Sundararaman_S1

You can build an Excel add-in that lets users pick and run UiPath jobs. The add-in calls Orchestrator APIs to list available jobs and start the selected job, passing Excel data as input arguments. Authenticate the add-in to Orchestrator using OAuth or API key. This keeps the whole experience inside Excel without using Studio or Assistant.

4

You can try using API trigger with API call from Excel.
but In this case you need to focus on the security aspect of your API call.

Limitations

5

Thank you for the reply,

It is little more than just triggering the workflow.
I would need to push the data from the active worksheet as an input arg to the job and then write the output at specific columns.

All in all, the user experience should be - I load the data into an excel worksheet, I run the job, I see the output on the same sheet.