How to add new row instead of replacing existing data

Help Activities
, ,
1

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
image503×611 25.1 KB

image
image496×642 22.8 KB

image
image482×708 26.4 KB

image

2

Hi,

Place the Write range activity outside the loop

Thanks

3

Hi @WS_Chai

Use insert rows activity.

4

Hi,

@rlgandu Thanks for your reply.

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

image

5

Hi,

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

Thanks