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.
second to last row , i did not get the point?
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
try this logic
data.xaml (8.2 KB)
excel file used Book1.xlsx (9.4 KB)
what activity did you use so that i can install it?
Use add data row activity
In that add the array as dt1.Rows(dt1.Rows.Count-1).ItemArray
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.