How to add new row instead of replacing existing data

Hey there,

I would like to document the result from an automated checking in an excel file summary.
As the bot checks through each file in a folder, I want the bot to document the result in the next (new) row.

However, I am not sure why the result is not documented in the next row when it loops through another file. Instead, it keeps updating the first row. As a result, then the bot has done running the activities, instead of 3 results I can only see 1 line.




image

Hi,

Place the Write range activity outside the loop

Thanks

Hi @WS_Chai

Use insert rows activity.

Hi,

@rlgandu Thanks for your reply.

I have moved it outside the loop.
But got this error instead.

image

Hi,

In write range you give range right. So please remove the range or simply give ""double quotes without Space

Thanks