I need some help to identify what is going on with the my code.
I am having issues while writing datatable in excel tab. I have 3 write range activity in Excel Application scope. Error occurred on 3rd Write range activity. However, if I move last write range out of Excel application scope and create a new Write range Excel activity. It’s working fine.
Problem is my entire flow was working in when I last ran. Since today morning I am facing this issue.
I am writing the datatable in a worksheet which already has header on row 2 and I am writing datatable from A3. Below is the error message.
RemoteException wrapping UiPath.Excel.Excel Exception: Could not write the data table starting with cell A3. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
Yes, If last write range activity is moved out from Excel application scope and add as Workbook Write range with same path, sheet name, range and datatable. It is working fine. But I am running a macro on the same excel after last write range, I am getting another error on Execute Macro.
But earlier, my workflow was working fine with all write range & Execute MAcro within same excel application scope.