Copy sheet - RemoteException wrapping System.InvalidCastException: Unable to cast COM object of typ

Help Activities
, , , , , ,
1

Copying sheet to another sheet using copy sheet throws an error . Any idea ? thanks. Excel version 2016

act
act898×617 12.5 KB

Error
>
> RemoteException wrapping System.InvalidCastException: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).
> at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
> at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
> at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

2
  1. Check if the excel is being created.
  2. Check if the sheet you want to copy exists in the excel.
  3. Close the excel while running the bot.
4

Hi @AhmedKutraphali

Could you share the excel file and screenshot of the properties panel of copy sheet activity.

Thanks

5

I also have the same problem. Anyone can kindly advice? Thank you very much