32bit Excel

Please enable StudioX to work with 32bit Excel. I have had to give up on the RPA course because my Excel was not recognised by the programme.

StudioX should work with Excel 32 bit. What exactly does not work? The plugin( you cannot indicate) or you cannot execute an workflow?

Hi Mircea,

I cannot execute on workflow.

Best regards,

Klara

Hello,

Can you please provide us with an error message and some logs.

Dragos.

Hi,

Here you go:

All relevant screenshots, logs etc:

Something went wrong with Excel.
Activity Use Excel File (Excel Application Card) failed:

Error opening workbook. Make sure Excel is installed.

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)).

You can find the activity following this path:

Main > Use Excel File.

Excel file path: [string.Format("{0}\RPA\Robot Path - Working Documents\Robot Path.xlsx", Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments))]

RemoteException wrapping System.Exception: Error opening workbook. Make sure Excel is installed. —> 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.ExcelHelpers.StartNewApplication()

— End of inner exception stack trace —

at UiPath.Excel.Helpers.ExcelHelpers.StartNewApplication()

at UiPath.Excel.Helpers.ExcelSingleInstanceManager.StartOrAttach(Boolean& wasAlreadyRunning)

at UiPath.Excel.ExtendedWorkbookApplication.ExtendedAttachOrCreateNew(WorkbookArguments workbookArguments, IExcelInstanceManager instance)

at UiPath.Excel.ExtendedWorkbookFactory.Create(Boolean attachOnly)

at UiPath.Excel.WorkbookQuickHandle.SafeGetWorkbook(Boolean attachOnly)

at UiPath.Excel.WorkbookQuickHandle.OpenWorkbook()

at UiPath.Excel.Activities.Business.ExcelApplicationCard.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)

Best regards,

Klara

(Attachment 2020-05-22_Studio.log is missing)

(Attachment 2020-05-22_Analyzer_Studio.log is missing)

(Attachment 2020-05-22_DbServer_Studio.log is missing)

(Attachment 2020-05-22_ExcelAddIn_Install.log is missing)

(Attachment 2020-05-22_Execution.log is missing)

Resending without log attachments as rejected.

The error is caused by a corrupted Office( excel in this case) installation. The solution is to navigate to Program and Features and Repair office installation (another solution is to edit the registry key but I recommend the first one).

1 Like