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)).
It might be a bit complicated for us to debug this based on the screen shot alone 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
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)
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.