Dynamically add data in a position in Excel

Help Studio
, ,
1

Hi,
I am looking to dynamically add data on the second to last row every time i scrape data and load into data table.
Ill appreciate any suggested idea to accomplish this.
Thank you
image

2

second to last row , i did not get the point?

3

an example is the picture above. if i want to add another data say “Kim, 34, 67”, i would want t it to be in row “6” and the current row 6which is “Adam, 33, 88” would move to row 7

and this would happen every time i have a new row. i want “Adam, 33, 88” to always be the last row

4

Hi @Ayodeji_Osikoya

try this logic
data.xaml (8.2 KB)

excel file used Book1.xlsx (9.4 KB)

Regards,
Nived N

5

image

what activity did you use so that i can install it?

6

Use add data row activity

In that add the array as dt1.Rows(dt1.Rows.Count-1).ItemArray

1 Like
7

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