Add excel value at new row in specified column

Help
1

Hi,

For an example,
There already data at A5:A10
I want to insert new value starting from B5.

Thanks so much!

2

Hi @mashy2,

use write range activity change rage from B5
image

1 Like
3

@mashy2

  1. First use Read Range activity to read data from that sheet and store result in DataTable.
  2. And then use Append Range activity to append data to the above dataTable.
4

hi @Gouda_6 and @lakshman,

I have tried ur suggestion but still it output no result,

Kindly see my workflow

Book1.xlsx (10.2 KB)
book2.xlsx (9.0 KB)
insert rc value11.xaml (9.9 KB)