How to dynamically get last entry of an excel & append?

Hi All,

I’m trying to append some data (eg. mar, apr) below the existing jan & feb.
The 1st time it gets what I wanted but gets lower everytime I ran it.

I need to dynamically read last entry(feb), assign, create datatable & append new data right below.

Any tips is appreciated!

hi @RUI_QI,

Read particular row/column and check it’s length then you will get last value, based on that u can add data at last.

Thank you!

@RUI_QI
You can use Append Range Activity.

Regards,
Mahesh

get the row count value and process it with for each row then append the values with count+1 in the particular cell.