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!

You can use Append Range Activity.


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