Write range into a specific column without overwrite old data

Help Studio
, , , ,
1

HI All,

i am new to RPA program. i already try many way to paste the data table into a specific column but failed. please help me. thanks in advanced!

2

Hi @PME_RPA

Write Range activity will overwrite the old data, if you want to use the write range without overwriting the old data then you need to find the last used row and pass row number in the Range property

Thanks
John

3

data will be added by weekly.do you have any recommend instead of using write range? i am also need to paste the data to “Specific column” created.

4

You can follow the example given below

I am writing data into D column which already have some data.

  1. Read Range will give dt_RowOuput, from this output I will find out how many rows are there in the excel.
  2. Used Remove Data Row to Remove the header in the data table to avoid writing header for every new entry
  3. In the Write Range activity, I will pass the Range value as below, so bot will update the new data under old data.

“D”+(dt_RowOutput.Rows.Count+1).ToString

image
image1412Ă—860 48.4 KB

Note: Uncheck Add Header option in the Write Range activity

Thanks
John

5

Got ERROR
Remove Data Row: Object reference not set to an instance of an object.

2
21117Ă—635 44.6 KB

6

1
11136Ă—602 52.4 KB

7

3
31086Ă—457 46 KB

8

Hi @PME_RPA

Can you share the screenshot of Sheet2 and DT1.
Knowing how the column headers and structure look will help in resolving the issue.

9

Hello @PME_RPA

If you use Write Range it will overwrite the existing data. So try to use the Append Range activity and write to the respective column. It should work.

Thanks

10

image
image874Ă—233 3.25 KB

11

may i know how to write respective column? i try many ways cannot

12

Hi @PME_RPA

Remove Data Row did not work like I expected. so here is a modified approach.

Step 1: When Reading the DT1 table, read from next row to avoid headers

For Example, A1 row contains headers for the table. so, I am reading from A2 row

image
image1300Ă—589 25.7 KB

Step 2: In the write range activity pass the Range value as below, so bot will update the new data under old data.

“B”+(dt_RowOutput.Rows.Count+1).ToString

image
image1398Ă—715 34.7 KB

13

@PME_RPA

Try to do as below.

Use Write Datatable to Excel activity and enable Append property.

image

Thanks

14

i try this method but the data keep overwritten.

15

may i knowwhich package activieties?and the version. thanks!

16

Hi All,
i got the answer. same as johnfelix… thanks All
image

1 Like
17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.