Hi Guys
I’m doing some tests using UiPath and I’m trying to store some data in Excel using UiPath robot.
I’ve created this sequence:
But when I try to insert some function inside Excel it stops working, showing the following error
with this error output:
RemoteException wrapping UiPath.Excel.ExcelException: Exception from HRESULT: 0x800A03EC —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.set_Value(Object RangeValueDataType, Object )
at UiPath.Excel.WorksheetMetadataOperations.<>c__DisplayClass7_0.b__1(Range destinationRange)
at UiPath.Excel.WorksheetMetadataOperations.InternalAppendRange(ExcelRangeInfo rangeToAppendTo, Int32 rangeToCopyRowCount, Int32 rangeToCopyColumnCount, Int32 startingColumnIndex, Boolean transpose, Func`2 write)
at UiPath.Excel.WorksheetMetadataOperations.<>c__DisplayClass7_0.b__0()
at UiPath.Excel.ExcelContextHelper.Execute(Action action, ExcelContext context, Object contextParams)
— End of inner exception stack trace —
at UiPath.Excel.ExcelContextHelper.Execute(Action action, ExcelContext context, Object contextParams)
at UiPath.Excel.WorksheetMetadataOperations.AppendDataTable(DataTable source, ExcelRangeInfo rangeToAppendTo, Boolean excludeHeaders)
at UiPath.Excel.Activities.Business.WriteRangeX.<>c__DisplayClass20_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.WriteRangeX.d__20.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)
If I have only text it works pretty fine (even though it jumps some row before starts writing) but when I add formulas, any kind of it, it won’t work and it stops as soon as that formula should be written in the file.
This is my file:
The function ARROTONDA.ECCESSO.MAT is the CEILING function in my language.
This is the Excel output:
As you can see it jumps a lot of lines, and then starts writing until the formula happens.
Could you help me? Many thanks!