Write cell error : Failed setting the current sheet to & he object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))

Hi friends,

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

4 posts were merged into an existing topic: Write Cell ACtivity error