Excel Addi-in error

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

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

To better identify the Repair Tool For Microsoft Office:

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

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.

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.

Hello,

Can you post some logs / print screens ?

Regards,
Dragos.

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)

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