Welcome to the community!!
So, once you read the data in excel, you loop through each record and scrape the data right? and then, you come back and write the data back into excel one at a time i suppose?
In that case, in the write range activity, you can make the range property dynamic. So in your loop, have a counter variable starting from 2 (assuming you have headers in the first row). In every iteration, increment this counter variable by 1.
In the loop, have the write range activity, and for the range property make it something similar to this
–Assume you start writing from column D - suppose column A, B, C have data because you are writing to the same excel you used to read data
so the range property should look like
"D" + CounterVariable.ToString
So in every iteration, counter variable will have the row number. So it will not overwrite the existing data.
or else, If you are trying to write an entire data table that contains multiple records at once, you can actually use the Write Range for the first iteration. And for every other iteration, use the append range activity so that it will add the new records just below the existing data.
Does it help?
If this works for you, please make sure to mark my answer as the solution so it could help others a well