UiPath Excel Agent

Agentic Automation
1

I am working on an enterprise grade use case where I require to input 1.Excel File Path and 2. macro file path..The agent will execute the macro leveraging LLMs and will produce Output file…How to configure the agent ?

2

@Ritaman_Baral For this kind of use case you can keep the agent design simple.

  1. Inputs to agent
  • Excel file path
  • Macro file path
  • macro name or output path
  1. Agent step
    The LLM can first validate the inputs and decide which macro needs to run .
  2. Execution step
    Then call a normal UiPath workflow which will:
  • open the Excel file
  • load the macro workbook
  • run the macro (Run Macro / Invoke VBA)
  • save the output file
  1. Output
    Return the output file path or status back.

So basically the agent handles the orchestration, and the UiPath workflow does the actual Excel macro execution. In enterprise cases its usually better not to let the LLM control Excel directly.

Regards,
Dhruba

3

Thanks for your response.
My ultimate goal is to replace the traditional excel workflow with llm because traditional workflow is taking around 1 hour to run that particular macro

1 Like
4

@Ritaman_Baral are you able to configure Agent now? If yes please marked as Resolved

5

@Ritaman_Baral

I think your use case isn’t an agentic use case.

As you have fixed set of rules or steps and logic, I would suggest to explore RPA solution because LLM can’t just speed up the process.