I am currently trying to make a comparison between 2 Excel’s with data (each Excel has different headers, but the same data, Example: Excel1 → Volume = 1500; Excel2 → VOL = 1500).
To do this, I am using a “For Each” (Write_Cell.png) that contains an “Excel Application Scope” to open a .xls on which I want to write the result of the comparison.
However, in the “Write Cell”, it manages to write in the first cell where I indicate it, but then it jumps an error:
20.4.1 Source: Write Cell
Message: Could not write cell A2.
Exception Type: UiPath.Excel.ExcelException
RemoteException wrapping UiPath.Excel.ExcelException: Could not write cell A2. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
at UiPath.Excel.WorkbookApplication.WriteCell(String cellAddress, String data)
— End of inner exception stack trace —
at UiPath.Excel.Activities.ExcelInteropActivity`1.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)
And I’d like to know if someone can explain to me the fault and why they write to me once and skip the mistake.