When I am trying to use append range activity in excel application scope its throwing error as “Could not write the data table DataTable starting with cell A1”.
I tried to apply some delay before the activity and also added kill process for excel but I am still facing same issue.
Please provide some suggestion to overcome this issue.
I am using append range from Excel. Below are screenshot of my flow and excel. Actual flow is quite big but I have added snap where I am using the activity.
For read range count it showing 0 as there is no data right now in sheet.
Exception -
RemoteException wrapping UiPath.Excel.ExcelException: Could not write the data table DataTable starting with cell A1. —> RemoteException wrapping System.Runtime.InteropServices.COMException: The message filter indicated that the application is busy. (Exception from HRESULT: 0x8001010A (RPC_E_SERVERCALL_RETRYLATER))
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Dynamic.ComRuntimeHelpers.CheckThrowException(Int32 hresult, ExcepInfo& excepInfo, UInt32 argErr, String message)
Not sure which snapshot was required. I have added my flow snap which shows I am adding new row in exceptionList Table and that exceptionList table varible is added to Append range.
And while debugging its not throwing error for Add data row and add new row to it but throwing error on Append range.