Trouble with Use Excel File in Studio and StudioX

Help Studio
,
1

Hello,
I am a new user testing out the functionality for entering data from Excel into a web UI. My first test in Studio worked fine. Then I uninstalled Studio and installed the older version 23.10.13 in order to access StudioX. When I tried the Use Excel action in StudioX, I got an error that it could not open the Excel file. I ran the Repair Tool, checked the registry for any extraneous versions of the TypeLib key (there were none), to no avail. Then I thought maybe StudioX was the culprit, so I uninstalled it and reinstalled Studio 25.0.167. I’m still getting the same error with Use Excel.

The error message is not much help:

image
image1103×693 32.6 KB

The previous message under StudioX was more specific:
Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen.
Unable to cast COM object of type ‘System.__ComObject’ 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-000000000046}’ failed due to the following error: Error loading type library/DLL. (0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Can anyone advise where to go from here?

Forum Engagement Daily Reports
2

Hi @voronibrod

This might be intermediate issue, so you can kill the excel and try again .

happy Automation

3

Hi @voronibrod

Please check below post for resolution on same

4

Why would you do that? I mean, if the problem immediately started when you did that…

5

Thanks for the suggestion. Looking into the Microsoft Recovery Tool, I don’t think it will help me with Excel 2010. I’ve tried uninstalling and reinstalling the Excel add-on, and I even get an error doing that:

A UiPath Studio window is showing browser extensions and Excel add-in installation options alongside an error message related to a COM object loading failure. (Captioned by AI)
A UiPath Studio window is showing browser extensions and Excel add-in installation options alongside an error message related to a COM object loading failure. (Captioned by AI)1107×507 32.3 KB

I just wish I could get the system back to what it was a few days ago.

6

Hi @voronibrod, can you please give a try to bellow steps:

  1. First, update your Microsoft Office to a newer version—Office 2016 or later. Office 2010 is too old and often causes these types of errors with UiPath.

  2. Use the official Microsoft Support and Recovery Assistant tool to fully uninstall Office and then reinstall it. You can get it here:
    https://aka.ms/SaRA-OfficeUninstall-FromPC

  3. After reinstalling Office, open UiPath Studio, go to the Home tab, click on Tools, and run the Repair Tool for Microsoft Office Interop.

  4. Open Excel, go to File > Options > Add-ins, then at the bottom select COM Add-ins > Go, and make sure the UiPath Excel Add-in is checked and enabled.

  5. Open Task Manager and kill any Excel processes running in the background (look for EXCEL.EXE).

  6. Finally, restart your system and try running your process again.

If that still doesn’t fix it, uninstall both UiPath and Office completely, restart your PC, reinstall Office first, and then reinstall UiPath. This usually gets things back to normal.

7

Thanks everyone for the ideas. Reinstalling office or upgrading is not an option for me. But I decided to try repairing office from the Windows Apps settings tool. After the repair and rebooting, Studio will now open Excel files again! The registry key did not change, so I still don’t know exactly what was wrong, but I am up and running again.

1 Like
Forum Engagement Daily Reports
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.