Hi all,
I’m new to using the Studiox application and running into a runtime error with the ‘Delete Row’ command. The error is copied below and further details at the end.
Message: Exception from HRESULT: 0x800AC472
The entire workflow has ran a few times prior to this, but has continuously returned an error ever since. The rest of the activities will operate just fine if I disable the ‘Delete Row’ activity.
I realize it’s probably a simple oversight on my end, but I couldn’t seem to find a solution that worked; attempted a delay and saw a kill command, but it didn’t seem available in StudioX?
Any help from the community would be greatly appreciated. We’re trying to use this run as POC for our team’s automation efforts. I’m using Office 365 in case it’s a helpful detail. Thanks!
RemoteException wrapping UiPath.Excel.ExcelException: Exception from HRESULT: 0x800AC472 —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Application.Union(Range Arg1, Range Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
at UiPath.Excel.RowOperations.ExtendRangeAndRelease(Range& baseRange, Range& extensionRange)
at UiPath.Excel.RowOperations.FindRowsToDeleteOnCriteria(Range rows, Func2 matchesCriteria, Boolean isFullSheet) at UiPath.Excel.RowOperations.<>c__DisplayClass2_0.<DeleteRows>b__0(Range rows) at UiPath.Excel.RowOperations.<>c__DisplayClass6_2.<InnerDeleteRows>b__2() at UiPath.Excel.ExcelContextHelper.Execute[T](Func
1 func, ExcelContext context, Object contextParams)
— End of inner exception stack trace —
at UiPath.Excel.ExcelContextHelper.Execute[T](Func1 func, ExcelContext context, Object[] contextParams) at UiPath.Excel.RowOperations.InnerDeleteRows(String range, Func
2 findRowsToDelete)
at UiPath.Excel.RowOperations.DeleteRows(String range, String sheet, DeleteRowsOption deleteOption, Boolean isFullSheet, IEnumerable`1 indexesToDelete, Boolean deleteFirstRow)
at UiPath.Excel.Activities.Business.DeleteRowsX.<>c__DisplayClass16_0.b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Excel.Activities.Business.DeleteRowsX.d__16.MoveNext()
— End of stack trace from previous location where exception was thrown —
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.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)