I’m getting the below error while filling the data from datatable into specific cell using Excel application scope : Write cell activity.
Write Cell: Failed setting the current sheet to: Sheet3 in workbook: C:\Users\user\Pictures\OUTPUT_New.xlsx. Original error message: The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))
sometimes it is giving the above error randomly at mid point after filling 5 values out of 400.
sometimes it is giving the above error after it fills 200 values.
Please suggest me on how to resolve such error.
Thanks in advance