Robot
2023.4
false
- Release Notes
- Getting Started
- UiPath Assistant
- About UiPath Assistant
- UiPath Assistant on Mac
- Field Descriptions
- Automation Configuration
- Task Capture Launcher
- Assistant Governance
- UiPath Assistant for Excel add-in
- Installation and Upgrade
- Robot Types
- Robot Components
- Licensing
- Connecting Robots to Orchestrator
- Processes and Activities
- Logging
- Robot JavaScript SDK
- Specific Scenarios
- Restarting Robot Components
- Windows Sessions
- Login Using Thales Luna Credential System
- Login Using NShield Key Storage Provider
- Redirecting Robots Through a Proxy Server
- Executing Tasks in a Minimized RDP Window
- Using Mapped Network Drives
- Stopping a Process
- Disable Stop Button
- Custom Package Folders and Network Paths
- CrowdStrike Integration
- Robot Citrix Apps Virtualization
- Troubleshooting
- Unresponsive Robot Over RDP
- Duplicate Execution Logs
- Frequently Encountered Robot Errors
- Increased Process Execution Duration
- Enforced Package Signature Verification
- Message Too Large to Process
- Errors When Running as Administrator
- NuGet Packages Not Accessible After Migration
- User Access Control Prompt and UI Automation Activities
- .NET required during installation
- Assembly Cannot Be Loaded From Network Or Azure File Share
- Activities cannot find .NET Runtime
UiPath Assistant for Excel add-in
Robot User Guide
Last updated Apr 3, 2024
UiPath Assistant for Excel add-in
The UiPath Assistant for Excel add-in allows you to use UiPath Assistant capabilities in the native Excel application. This provides an easy way to run, manage, and configure Excel-specific automations without having to switch between applications.
- UiPath Assistant 2023.4.2 or higher connected to Orchestrator with an attended license.
- At least one automation with the
excelAddin
tag or created with the "UiPath Assistant for Excel Process" Studio Template. - Microsoft Excel 2016 or higher, or Microsoft 365 Excel online.
Note: The UiPath Assistant for Excel Add-in does not currently support Excel for macOS or non-chromium based browsers when used in Excel online.
The UiPath Assistant for Excel add-in can be installed directly from the Microsoft Store, or using a manifest file to manually add it on your machine or deploy it to multiple machines it in your environment.
Important: The Microsoft store always
provides the latest version of UiPath Assistant for Excel add-in, which can break
compatibility with older versions of the UiPath Assistant. Because of this, installing
the add-in from the Microsoft store is recommended exclusively for Community users. For
Enterprise users, we recommend deploying the add-in using the manifest file to ensure
compatibility.
-
Access this link and select Get it now.
Note:
Alternatively, you can add the UiPath Assistant for Excel add-in directly from the Get Add-ins section in the Excel application.
You need to be signed in to Microsoft Store to complete the download.
To do this, follow the steps below:
- In Microsoft Excel (both desktop and online), open a spreadsheet, then go to the Insert tab.
- Click Get Add-ins, enter the WA200005457 ID in the search box, and click Add.
In Excel Desktop
The add-in is enabled through the manifest file using a process called "Side-Loading". This is done based on the steps below:
- Download the manifest file from the Product Downloads section in Customer Portal.
- Follow the steps described in the Microsoft documentation on this topic.
- In Excel, go to the Insert tab, and click My Add-ins, select Shared Folder, click on the UiPath tile, and select Add. A new tab called UiPath appears on the Microsoft Excel toolbar.
- Select the UiPath tab -> Find Automations to see the UiPath Assistant for Excel add-in.
In Excel Online
- In Excel Online, open a spreadsheet, then go to the Insert tab.
- Click Add-ins > My Add-ins.
- Click Upload my Add-ins, and browse to the manifest file.
Admin deployment
- Download the manifest file from the Product Downloads section in Customer Portal.
- In a cloud deployment environment, you can deploy the add-in to your organization by using the Microsoft 365 admin center. Read more about using Integrated Apps or Centralized Deployment.
Note: When the add-in is loaded for the first time, the latest version available is used. Once the connection with the UiPath Assistant
is created, the add-in version syncs to the Assistant one.
When you open the UiPath Assistant for Excel add-in for the first time, if Assistant is not running, you are prompted to launch
it.
If you are not logged in the UiPath Assistant, or if no automations are available, make sure you are connected to Orchestrator
with a valid attended license, and you have at least one automation that has the
excelAddin
tag deployed for your account.
To create an automation for the UiPath Assistant for Excel, use the dedicated Studio template with the same name. This template features the
excelAddin
tag and two input arguments (in_FilePath
and in_Selection
) that populate at runtime, making it easier to pass data between Excel and the automation. Since these automations have the
excelAddin
tag, they are automatically added to the UiPath Assistant for Excel add-in once published.
You can also create your own automations, making sure that they have the
excelAddin
tag. To benefit from either of those input arguments, they need to be created/used inside the workflow.
When the
in_FilePath
and in_Selection
input arguments are present in an automation created for the add-in, they are automatically populated as follows:
- in_FilePath (String) - represents the file path from which the add-in is starts the process.
- in_Selection (String) - represents the cell/cells selected when the process is starting.
Note: If you need more selections, create additional input arguments, new range variables, and new sheet variables if your selection
is from a different sheet. Afterward, you can drag and drop the Parse Excel selection workflow into your main sequence and
import the newly created arguments and variables.