- Release Notes
- Getting Started
- Setup and Configuration
- Automation Projects
- Dependencies
- Types of Workflows
- File Comparison
- Automation Best Practices
- Source Control Integration
- Debugging
- The Diagnostic Tool
- Variables
- Arguments
- Imported Namespaces
- Trigger-based Attended Automation
- Recording
- UI Elements
- Control Flow
- Selectors
- Object Repository
- Data Scraping
- Image and Text Automation
- Citrix Technologies Automation
- RDP Automation
- Salesforce Automation
- SAP Automation
- VMware Horizon Automation
- Logging
- The ScreenScrapeJavaSupport Tool
- The WebDriver Protocol
- Test Suite - Studio
- Extensions
- Troubleshooting
- About troubleshooting
- Microsoft App-V support and limitations
- Internet Explorer X64 troubleshooting
- Microsoft Office issues
- Identifying UI elements in PDF with Accessibility options
- Repairing Active Accessibility support
- Automating Applications Running Under a Different Windows User
- Validation of large Windows-legacy projects takes longer than expected
Excel Add-in
The Excel Add-in enables Studio to integrate with Microsoft Excel, allowing you to seamlessly switch between Studio and Excel to indicate the data you want to use directly from Excel files added to your automations. Indicating in Excel is available by default in StudioX, while in Studio it requires UiPath.Excel.Activities v2.11.0 or later with the Modern Design Experience for Excel enabled.
- Save and close all open Excel workbooks.
- In Studio, select Home > Tools > UiPath Extensions > Excel Add-in.
- Click OK to confirm you have saved and closed all Excel workbooks.
-
The add-in is installed and a confirmation message is displayed. Click OK to close the message.
To verify that the add-in has been successfully installed:
- Open or create a project in the StudioX profile.
-
Add an activity, for example Write Line, select Plus
on the right side of a field, and then select Project Notebook (Notes) > Indicate in Excel.
-
If the workbook is opened in Excel and there is a UiPath tab in the ribbon with Confirm and Cancel options, the add-in is installed and working as expected.
Do the following, and then try to install the add-in again:
-
Make sure a supported version of Microsoft Excel is installed and is licensed with a valid product key. Studio is compatible with Microsoft Office 2013 and later.
Note: The add-in is not compatible with Microsoft Excel installed from the Microsoft Store. To find out the installation type, open Excel, select File > Account, and then, under About Excel, check that the line with the version number does not end with "Microsoft Store" or "Windows Store". -
Open the Windows Task Manager and check if any instance of Microsoft Excel is running. If that is the case, right-click it and select End Task.
-
Make sure macros are not disabled in Excel. Open Microsoft Excel and select File > Options > Trust Center > Trust Center Settings > Macro Settings. We recommend selecting the options Disable VBA macros except digitally signed macros and Enable Excel 4.0 macros when VBA macros are enabled.
- If the error states that Excel is not installed even though it is installed, Excel might be corrupted. Repair or reinstall Microsoft Office.
There are a number of issues that can prevent the Excel add-in from working. Use the steps provided for each issue to try to correct it.
All add-ins are disabled
- Open Microsoft Excel and select File > Options > Trust Center > Trust Center Settings > Add-ins.
-
If Disable all Application Add-ins is selected, deselect this option.
The Excel add-in is disabled or inactive
-
Open Microsoft Excel and select File > Options > Add-ins.
-
If UiPath.Integration.ExcelAddin appears in the list of Inactive Application Add-ins follow these steps to activate it:
- From the Manage drop-down at the bottom of the window, select COM Add-ins, and then click Go.
-
In the COM Add-ins window:
- If UiPath.Integration.ExcelAddin is not selected, select it.
-
If UiPath.Integration.ExcelAddin is selected, see if the Load Behavior message displays any information about why it is not loaded. If the message states that a user setting is preventing the add-in from loading, try to change that setting.
-
If UiPath.Integration.ExcelAddin appears in the list of Disabled Application Add-ins, follow these steps to enable it:
- From the Manage drop-down at the bottom of the window, select Disabled Items, and then click Go.
-
Select UiPath.Integration.ExcelAddin and click Enable.
UiPath is not in the list of trusted publishers
- Open Microsoft Excel.
- Select File > Options > Trust Center > Trust Center Settings.
-
If the UiPath certificate does not appear in the list of Trusted Publishers, add it. Only an administrator can do this. If you do not have permissions, contact an administrator in your organization.
If problems persist, manually install the Excel add-in
C:\Program Files\UiPath\Studio for per-machine installations or %localappdata%\Programs\UiPath\Studio for per-user installations) and double-click the file UiPath.Integration.ExcelAddIn.vsto located in the net461 subfolder. If the add-in is successfully installed, a confirmation message is displayed.
If nothing happens when you select Home > Tools > Excel Add-in, your antivirus software may be preventing the installation. Try to manually install the add-in.
