I am using data scraping inside for each loop so my question is how can I write new data in the same excel sheet when using a loop instead of getting data written over and over again?
hi
you can try some thing like below
Initialize counter value i.e counter = 1
in a loop
use if activity and give condition like “counter =1”
then
use write range activity and pass necessary inputs
else
use append range activity with same inputs as write range
increase the counter value out side if
Thanks