Write Cell: Failed setting the current sheet to sheet 2 in workbook and The Object invoked has disconnected from its clients error in Uipath

Help Robot
, ,
1

My UiPath robot throws an error after writing two cell. It says
Write Cell: Failed setting the current sheet to sheet 2 in workbook and The Object invoked has disconnected from its clients error in UiPath

I have checked the excel file and sheet name there’s no problem with that. what might be reasons for getting error?
there’s completed column in my excel sheet after reading each row. It read the first row in the loop and throws an error before completing second row.

2

HI @Samraat_Maharjan

May be a Kill process and a delay before this excel writing activities can solve this , Can you check once?

Regards
Sudharsan

3

I have to read 3K rows in an excel sheet. Where do I use the Kill activity and how? Can you explain in detail?
My bot read from an Excel file, enter the Customer Id, and then do some other function. Finally it put completed status in last column, which will be write in the same excel file.

4

Hi @Samraat_Maharjan ,

Could you let us know your implementation ?

Also, Maybe you could shift to a datatable approach of looping through the data and updating the values in the datatable and then at last write the Updated datatable back to Excel sheet.

5

thank you for your reply.

My bot login website (entering PW and username). It then clicks some value inside that website (say ABC) where there would be a customer id. And after clicking that value (ABC), it read and extracts values from excel (using read range), entering into the customer-id to see if its case has been submitted or not.
Upon finding, it has not been submitted, it submits the case and writes the cell value as completed. I have added an extra column in my excel sheet.

I used two assigned operators. (First assign - CurrentIndex = CurrentIndex+1)
Second Assign. writeCell = “E (my column name which is completed)”+ currentIndex.ToSting)

and then finally WriteCell
“Sheet1” → WriteCell (range)
“completed” as value

PS: I have also used filter chain data table so that I don’t have to execute the customer id with completed value in corresponding row.