Microsoft Office Issues & The Repair Tool Doesn't Help

Help Studio
, , ,
1

Hello all. I’ve tried to get Excel working with Studio and had no luck so far. When I use an Excel activity, I get a warning in the Output that says, “Use Excel File: Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen.”

Okay, cool. This is a documented issue and there’s solutions for it. I run the Repair Tool for Microsoft Office and try again. No luck. I run the online repair tool on my version of Office. Same result.

I did have two versions of Office installed on my machine, but I removed the older version, so I’m just running off an Office 365 (32-bit) version now. My version of UiPath Studio is 2025.0.157.

If I use the plain Workbook activities instead of the Excel activities, I’m actually able to edit Excel worksheets. But there seems to be a lot more functionality in the Excel activities and I’d prefer to use that.

I tried installing the Excel Add-In under Home>Tools to see if that would work. The install fails and gives the following error: "Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-00000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

I have uninstalled and reinstalled Microsoft Office 365 as well as UiPath Studio. I’ve run the repair tool in Studio many times.

2

Run the Repair Tool as Admin.
Restart the machine.
Check the behavior.
If the issue is still present, uninstall all the Office from your machine and install the 64 bit Office with Excel.
Upgrade the UiPath.Excel.Activities to the latest stable version.
Retry.
Let us know the results.