How to write for each variable in an excel?

[makboga]

Hi,
I read a variable named RefNumber in a web page for each variable in that web page I want to write it in an excel sheet.
How can I do that?
Thanks.

[Rahul_Unnikrishnan]

Hello @makboga

I hope you are getting some value from the Wepage and you need to write that data to excel cell one by one. If that is the case you can use the Write Cell activity.

If you want to write more number of rows then use a loop( while loop) and then increase the counter and use it in the cell range of write cell activity.

Thanks

Thanks

[Umadevi_Sanjeevi]

Hi @makboga ,

I hope you are getting the value of variable RefNumber inside for each row .

1. You can use assign activity inside for each row,

2. CurrentRow(“Your column name”) = RefNumber

3. Use write range outside of the for each row

Thanks!