Error opening workbook. Make sure Excel is installed

Scenario: Trying to launch Excel with “Excel application scope” but immediately get the following error:

“System.Exception: Error openning workbook. Make sure Excel is installed —> System.InvalidCastException: 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-000000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).”

Same error when trying to use Outlook through UiPath. Both applications work when using them outside UiPath.

Steps to reproduce:

Current Behavior:

Expected Behavior:

Studio/Robot/Orchestrator Version: UiPath Studio 2017.1.6435, Excel 2016 (16.0.8201.2200) 64-bit

Last stable behavior: Never worked.
Last stable version: -
OS Version: Windows 10 Enterprise
Others if Relevant: (workflow, logs, .net version, service pack, etc): I have tried to find solutions online, I have checked registry editor for multiple office entries, I have repaired and even reinstalled Office and UiPath without luck.

2 Likes

Install excel package

The UiPath.Excel.Activities and UiPath.Mail.Activities are installed

I tried to uninstall office, clean the registry with CCleaner and reinstall but still same error, so those solutions did not quite help me.

1 Like

I solved the problem the following way:

As I read that the problem was probably in regedit, I tried to find multiple entries of office but found nothing. Instead if I looked deeper into the TypeLib-key for Excel and Outlook there was a folder named “0” and inside that folders named Win32 and Win64. The problem is that I only have a Win64-installation of office, so I changed both keys values to match my current installation of EXCEL.EXE and MSOUTL.OLB. Now UiPath finds them.

7 Likes

Hi

I am facing the same issue Could you please provide the steps how to search for this solution provided ?

Thanks in advance

Well, if reinstallation of the Excel file won’t help you then try to disable the COM add-in

  1. From the File menu, click to the Options and then click Add-Ins.
  2. In the Manage list at the bottom of the screen, select COM Add-Ins item, and then click Go.
  3. Remove one of the add-ins from the list, and then click OK.
  4. Again try to open the excel workbook by double-clicking the icon or file name that you are trying to open.

Or else add Excel path to windows environment and restart your session. Hope doing this will help you to fix the issue

Source: www.repairmsexcel.com

Hello Affster, your solution seems to be the only solution so far for this Excel not working problem. Could you please provide more detailed steps for solving this problem through regedit? Which value to search for? Where do I find the TypeLib-key for Excel?
Thanks in advance for providing this explanation, I am stuck with not being able to read Excel files in UIPath. Martin de Groot

Did some digging because I have the same error (for Excel and Outlook). The path for the folders in question within regedit:
Excel:
HKEY_CLASSES_ROOT → TypeLib → {00020813-0000-0000-C000-000000000046}
Outlook:
HKEY_CLASSES_ROOT → TypeLib → {00062FFF-0000-0000-C000-000000000046}
Under each of these you have folders regarding various office versions.

But I only have a 32 bit office installed and for the last couple of weeks none of my office interactions are working anymore. On our machines with 64 bit versions of office this problem is not happening (we are currently upgrading to office 365, though our robot machines are not having their offices upgraded).

Could this be a mismatch between office versions and/or uipath package integration of these?

6 Likes

It didn’t work for me.

Hi

Is there any solution for this problem? I’m already trying this solution from other thread in this forum or another forum but with no avail. The error keep occurred.
Below is the solution that i already tried and still not solved the problem

  1. Add the variable environment in windows (excel path)
  2. Add excel path in Registry editor within user laptop
  3. Adding kill process for excel in robot at the beginning and at the end each robot
    (to clear the cache excel in the computer)
    Found the solution within forum Uipath and other forums)
  4. Disable add-ins in excel 2016
    Found the solution within forum Uipath and other forums)
  5. Repair the microsoft office

I think even when we reinstall the microsoft office the error will keep occurred because the principle just same with repair.

if you have any suggestion or solution for this problem please shared with me.

Thanks

BR

Delf

Yes this worked for me… Great… We need to remove Win32 entry, if we are using Office 64-bit. Or delete Win64 entry if we are using Office 32-bit
image

6 Likes