Error when delete row - System.Runtime.InteropServices.COMException: 0x800A03EC at System.RuntimeType.InvokeMember

[anon40731888]

Any ideas how to fix it?

22.10.3+Branch.master.Sha.def2351dc828ccfbcddb6e9e07c9cf71b5bf55da

0x800A03EC

System.Runtime.InteropServices.COMException: 0x800A03EC at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object providedArgs, ParameterModifier modifiers, CultureInfo culture, String namedParams)
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Object aArgs, Boolean aArgsIsByRef, Int32 aArgsWrapperTypes, Type aArgsTypes, Type retType)
at Microsoft.Office.Interop.Excel.Range.get_Range(Object Cell1, Object Cell2)
at UiPath.Excel.Helpers.RangeHelpers.<>c__DisplayClass3_0.b__1(IEnumerable1 rowBatch) at System.Linq.Utilities.<>c__DisplayClass2_03.b__0(TSource x)
at System.Linq.Enumerable.SelectEnumerableIterator2.MoveNext() at UiPath.Excel.RowOperations.InnerDeleteRows(String range, Func2 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__DisplayClass17_0.b__0()
at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
— End of stack trace from previous location —
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
— End of stack trace from previous location —
at UiPath.Excel.Activities.Business.DeleteRowsX.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

[Irene]

Can you share the code that threw this exception?

[anon40731888]

Sure this is the code:

This error is before delete rows.

[marian.platonov]

“An error occurred if the Windows regional format was not set to English (United States) and you ran a project that used a Delete Rows activity with the option All visible rows on a range that included hidden rows.”

Reference: https://docs.uipath.com/activities/other/latest/productivity/release-notes-uipath-excel-activities#bug-fixes

Can you try https://download.uipath.com/versions/23.4.2/UiPathStudio.msi with UiPath.Excel.Activities 2.20.2 or 2.20.1 package versions?

Which are the results?

[anon40731888]

Hello

I changed the regional format to US English instead downloading new version for now.

It worked no error anymore.

Thank you