How to write each row status

I need help on how to write status “OK” for each row in excel.Only when the row completed in a loop

@ks185332

Use foreach activity and mention the datatable variable

then use Assign Activity
row(“Status”)=“OK”

Inplace of Status you can mention column name.

Regards,
Mahesh

1 Like

In for each row m using write cell activity and it throws with an error of “Write Cell : The range does not exist” I need what wud be in range.

@ks185332
@ks185332

Use foreach activity and mention the datatable variable

then use Assign Activity
row(“Status”)=“OK”

Inplace of Status you can mention column name.

After this use write range to write in excel sheet ,it will work

Regards,
Mahesh

please check is this is your= are taking about image m still geetinf range doesnot exist
please help me with the range

@ks185332
In Write range Activity, in place of range just mention like this “”

Regards
Mahesh

1 Like

still not working

Hi @ks185332 ,

Try to use write range activity after for each row activity and pass the data table it will work.
Regards,
Arivu :slight_smile:

Sory its my mistake now its workin. Thanks :slight_smile:

Hi @ks185332,
It’s possible to give without column name I need to prefer index of the column like {B column, C column} like that?

Regards,
@Spark_robot