Excel Addi-in error

Help StudioX
,
1

Hi, hoping someone can help - i receive the following when trying to install the Excel Add-in in StudioX community 2021.4.0. I have Office 2013 with all updates

Error

Setup Extensions X
Unable to cast COM object of type ‘Microsoft.Officeinterop.Excel.ApplicationClass’ to interface type ‘Microsoft.Officeinterop.Excel._Application’. This operation failed because the Querylnterface call on the COM component for the interface with 11D1000208D5-0000-0000- C000-000000000046}’ failed due to the following error: Library not registered. (Exception from HRESULT: Ox8002801D (TYPE_E_LIBNOTREGISTERED)).

thanks

2

On tools tab you have the office repair tool. Can you run that and after taht try again?

3

To better identify the Repair Tool For Microsoft Office:

image
image741×285 16.8 KB

image
image1041×559 34.9 KB

4

修复完一直还是显示错误，

image
image1619×1018 80.5 KB

5

Hello,

It might be a bit complicated for us to debug this based on the screen shot alone :frowning: Most helpful would be if you could provide us with the logs (%localappdata%/UiPath/Logs) and also please do consider that most of us are proficient in English :frowning:

Regards,
Dragos.

6

Facing the same issue with Excel 2013 and UiPath 2022.4.1.

Tried reinstalling the MS Office and ‘Repair Tool for Microsoft Office’ in UiPath Studio.

7

Hello,

Can you post some logs / print screens ?

Regards,
Dragos.

8

Got the below error,

RemoteException wrapping UiPath.Excel.ExcelException: Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen. —> RemoteException wrapping 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)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.set_SheetsInNewWorkbook(Int32 RHS)
at UiPath.Excel.Helpers.ExcelInteropHelpers.GetNewComApplication()
— End of inner exception stack trace —
at UiPath.Excel.Helpers.ExcelInteropHelpers.GetNewComApplication()
at UiPath.Excel.Helpers.ExcelInteropHelpers.StartNewApplication(ExcelStartOptions options)
at UiPath.Excel.Helpers.ComApp.ExcelComAppReferenceCountManager.InternalComAppReferenceCountManager.StartNewApplication(ExcelStartOptions startOptions)
at UiPath.Shared.ComAppReferenceCountManager`3.StartOrAttach(TComAppStartOptions startOptions, Boolean killOnJobClose, Boolean& wasAlreadyRunning)
at UiPath.Excel.Helpers.ComApp.ExcelComAppReferenceCountManager.StartOrAttach(ComAppOptions comAppOptions, ExcelStartOptions excelStartOptions, Boolean& wasAlreadyRunning)
at UiPath.Excel.WorkbookApplication.AttachOrCreateNew(WorkbookArguments workbookArguments)
at UiPath.Excel.Activities.ExcelApplicationScope.<>c.<.ctor>b__53_0(WorkbookArguments args)
at UiPath.Excel.Activities.ExcelApplicationScope.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

9

Lot of trail and error, but in the end, resolved it through MS office upgrade from 2013 to 2016.

10

Ways To Fix Error Loading Excel Solver Add-In
Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.
Preview the repaired files and click Save File to save the files at desired location.

Regards,
Rachel Gomez