How to write each row status

excel

#1

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


#2

@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


#3

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.


#4

@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


#5

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


#6

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

Regards
Mahesh


#7

still not working


#8

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:


#9

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


#10

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