To update status in excel

Hi everyone, I m trying to update status after autmating a process on excel sheet. After the automation, I want to update status as done in excel sheet. Any ideas and suggestions would be helpful.

Hi @Tejaswini_Yadav1

Use this Assign Inside the For each Row in Data Table activity

You can use Assign activity

LHS : Currentrow("Column Name")
RHS : "Done"


Hello @Tejaswini_Yadav1

Please check the below similar post.


it as to update the status automatic after complete to loop


Use one assign activity inside the loop at the end, there you can update the status whether it’s successful or failure. Then all transaction status is stored in data table

Finally update it with the data table using write range activity