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