I am getting the below error while data is loading into excel cell . The robot is looping into for each row and writing it into the specific cell range.
Write Cell: Failed setting the current sheet to: Sheet3 in workbook: C:\Users\user\Pictures\OUTPUT_New.xlsx. Original error message: Exception from HRESULT: 0x800401A8
I’m getting this error multiple time for 3 different columns.
I have seen some of the posts regarding this error and few friends suggested me to put delay of 3 seconds before and after excel application scope
even though I put 3 seconds delay still it is stuck at some value and unable to fill the rest of the values. as it is filling 10 values out of 300 and while at the time of filling 11th value, it is throwing me the above error.
Thanks in advance!