Delete Rows: Exception from HRESULT: 0x800A03EC

i have problem to delete all visible row with filter condition. but I tried not using filter conditions, activity delete row worked. I have also tried to kill the excel process before the activity runs. can anyone provide input?
thank you for your respons

following activities,

HI @WICAKSONO_Hanif

Before the Use Excel File Activity

Use a Kill Process (Check Continue on Error) and Delay of 3 Seconds

Regards
Sudharsan

hi sudharsan,
thanks for your advice, but the error still appears when the activity delete row. the following description :

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

First try to give a specific range

Or
Try with classic delete row activity if you cant see classic activities

image

Check this filter panel you will have a option called Show Classic @WICAKSONO_Hanif
image

Regards
Sudharsan

hi @Sudharsan_Ka,
for the error is still the same, here’s the log attachment

20:55:39.1565 => [ERROR] [UiPath.Studio.App.Logging.OutputLogger] [34] Filtering: Exception from HRESULT: 0x800A03EC
20:55:39.3353 => [ERROR] [UiPath.Studio] [53] RemoteException wrapping System.Exception: Cannot evaluate ‘$exceptionDetails’ at current context. —> RemoteException wrapping System.Activities.InvalidWorkflowException: The following errors were encountered while processing the workflow tree:
‘VisualBasicValue’: Compiler error(s) encountered processing expression “$exceptionDetails”.
Character is not valid.

at System.Activities.Validation.ActivityValidationServices.ThrowIfViolationsExist(IList1 validationErrors, ExceptionReason reason) at System.Activities.WorkflowInspectionServices.CacheMetadata(Activity rootActivity, LocationReferenceEnvironment hostEnvironment) at UiPath.Activities.Debugger.VBRValueEvaluator.TryEvaluateExpression(String expressionString, Type locationValueType, LocationReferenceEnvironment locationReferenceEnvironment, CodeActivityContext context, IList1 referencedAssemblies, IList1 includedNamespaces, Object& result) --- End of inner exception stack trace --- at UiPath.Activities.Debugger.VBRValueEvaluator.TryEvaluateExpression(String expressionString, Type locationValueType, LocationReferenceEnvironment locationReferenceEnvironment, CodeActivityContext context, IList1 referencedAssemblies, IList1 includedNamespaces, Object& result) at UiPath.Activities.Debugger.VBExpressionEvaluatorBase.Evaluate(String expressionString, Type locationType, IList1 referencedAssemblies, IList1 includedNamespaces) at UiPath.Activities.Debugger.DebugInfo.EvaluateExpression(String expressionString, IList1 referencedAssemblies, IList1 includedNamespaces, ExpressionLanguage expressionLanguage) at UiPath.Executor.Tracking.DebugTrackingParticipant.EvaluateExpressionInternal(String expression) at UiPath.Executor.Tracking.DebugTrackingParticipant.EvaluateExpression(String expression) at UiPath.Executor.DebuggerPlugin.EvaluateExpression(String expression, CancellationToken cancellationToken) at lambda_method(Closure , Object , Object[] ) at UiPath.CoreIpc.Server.Method.Invoke(Object service, Object[] arguments) at UiPath.CoreIpc.Server.<>c__DisplayClass7_3.<.ctor>g__MethodCall|8() at UiPath.CoreIpc.Server.<>c__DisplayClass7_3.<<-ctor>g__InvokeMethod|6>d.MoveNext() --- 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.CoreIpc.Server.<>c__DisplayClass7_1.<<-ctor>g__HandleRequest|3>d.MoveNext() --- 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.CoreIpc.Server.<>c__DisplayClass7_2.<<-ctor>b__5>d.MoveNext() --- 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.CoreIpc.Helpers.<Timeout>d__91.MoveNext()
20:55:47.5957 => [ERROR] [UiPath.Studio] [20] MakeRelative error System.UriFormatException: Invalid URI: The format of the URI could not be determined.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind, UriCreationOptions& creationOptions)
at System.Uri…ctor(String uriString)
at UiPath.Shared.Extensions.PathExtensions.MakeRelative(String filePath, String referencePath, Boolean enforcePrimaryDirectorySeparator)
20:56:12.2331 => [ERROR] [UiPath.Studio.App.Logging.OutputLogger] [69] Delete Rows: Exception from HRESULT: 0x800A03EC

Hello @WICAKSONO_Hanif

Try this

  1. Repair MS Excel. Refer to this thread it may help you
    Update and Repair Excel
  2. Otherwise try to use delete activity on the same excel application scope instead of 2 different scopes.
  3. If different scope, Use kill outside the if condition with check true for continue on Error Property

Seems like you are trying delete all the rows @WICAKSONO_Hanif

Can you try with these two activities?

image

Regards
Sudharsan

I mean any one of them

hi @Gokul_Jayakumar,
I have tried for point 2 and 3 and run the same error. but I will try to point to one.

Thank you for the advice

hi @Sudharsan_Ka,

right, I will delete all visible rows. but the filtered data is still there

hi @Gokul_Jayakumar,
I’ve tried point 1 and the result is still an error. here’s the log attachment

08:42:24.3638 => [ERROR] [UiPath.Studio] [47] MakeRelative error System.UriFormatException: Invalid URI: The format of the URI could not be determined.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind, UriCreationOptions& creationOptions)
at System.Uri…ctor(String uriString)
at UiPath.Shared.Extensions.PathExtensions.MakeRelative(String filePath, String referencePath, Boolean enforcePrimaryDirectorySeparator)
08:42:58.9304 => [ERROR] [UiPath.Studio.App.Logging.OutputLogger] [92] Delete Rows: Exception from HRESULT: 0x800A03EC

Hello @WICAKSONO_Hanif
Cross check excel file whether the hyperlink(Like Email, website link) present in your file. It may cause the error.
If Exist, remove the hyperlink and try again.

hi @Gokul_Jayakumar
Screenshot 2023-01-13 140155

i have found the source of the problem. that’s from the advanced excel settings in the separator system section.
error when setting the decimal separator using symbols ( , ) and thousands ( . ). then I go back to the settings.

Thank you for your time to share information and suggestions

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.