Writing in Excel next row

Help Forum
1

Hi All,

Good day!

I have a doubt here, for an Example. I have to copy paste a share price daily with date.
If row one shows 18th March price means, row two should display 19th share price and row three should 20th share price.

I created to copy paste the share price for one date. If I run this tomorrow it is generating a new file with tomorrow date, instead of writing in next row of same sheet. Please advise.

2

Hi @abhilash.lohithakshan7 Welcome to the forum!

You can use the activity append range. That activity will write on the next empty row of the workbook.

Bests,
Andres

1 Like
3

Can you send a sample excel file? @abhilash.lohithakshan7

4

Hi @abhilash.lohithakshan7

Welcome to forum

What u can try is

Let say u had excel file having details of upto yesterday

Now u need to capture today’s data

What u had to do is

  1. Read the excel file and store in dt1

  2. Capture the data from web and then input to the datatable as a new row by using Add Data Row activitiy.

  3. Use write range to write the updated datatable to same excel file

Try this way

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed: