To update status in excel

[Tejaswini_Yadav1 (Tejaswini Yadav)]

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.

[Gokul001 (Gokul Balaji)]

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"

Regards
Gokul

[Rahul_Unnikrishnan]

Hello @Tejaswini_Yadav1

Please check the below similar post.

How to update status in excel sheet

[image] I am doing this for now. But its not writing in the excel sheet. Please let me know what is wrong in this. I need to write in the same excel sheet. Not the new one.

Thanks

[Tejaswini_Yadav1 (Tejaswini Yadav)]

it as to update the status automatic after complete to loop

[varunk (Varun Kumar)]

@Tejaswini_Yadav1

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

Thanks
Varun

[Praveen_Mudhiraj]

you can hardcode the ColumnName or you can create the ColumnName before starting the loop by using the Add Data Column and in the loop only based on condition you can use the Assign activity for Status = Done

for the reference you can see the below Screenshot

@Tejaswini_Yadav1