StudioX training - Currency Converter

Learn Academy Feedback
,
1

Hi,

I’m stuck in the Currency Conversion business case (StudioX training).

When using the “Write Cell” activity in order to put a formula in an Excel (QuantityPriceVLookUp Value), I’ve got the following error message :

*RemoteException wrapping UiPath.Excel.ExcelException: La plage n’existe pas. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception de HRESULT : 0x800A03EC *

  • à System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData)*
  • à Microsoft.Office.Interop.Excel.Range.set_Value(Object RangeValueDataType, Object )*
  • à UiPath.Excel.WorkbookApplication.WriteCell(String range, String data)*
  • — End of inner exception stack trace —*
  • à UiPath.Excel.WorkbookApplication.WriteCell(String range, String data)*
  • à UiPath.Excel.Activities.Business.WriteCellX.<>c__DisplayClass8_0.b__0()*
  • à System.Threading.Tasks.Task.InnerInvoke()*
  • à System.Threading.Tasks.Task.Execute()*
    — Fin de la trace de la pile à partir de l’emplacement précédent au niveau duquel l’exception a été levée —
  • à System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)*
  • à System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)*
  • à UiPath.Excel.Activities.Business.WriteCellX.d__8.MoveNext()*
    — Fin de la trace de la pile à partir de l’emplacement précédent au niveau duquel l’exception a été levée —
  • à UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)*
  • à UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)*
  • à System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)*
  • à System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)*

If you have any tips for me to go on. Thank you.

2

you are using a range that is not found in excel, maybe it is a table name or something like that…

3

The error code usually states that the file is being used or you have interrupted the process while it is running. Of course there are lot of possibilities for the same error, but make sure you are not doing these :slight_smile: