How to Get Recendly added row from excel

Hi,

I want to display the recently added data from Excel,… If any one know the answer please share me the answer…

thanks in advance

Hi, did you get a solution for your enquiry.
I have the same issue and couldn’t find the answer. If younhave it please help.

Thanks,

Fouad

Hi, @Fouad_Rechmani refer this,Ajith Task.xlsx (9.5 KB)
Main.xaml (18.1 KB)

and create one text file and store int value at default 0 …

Thank you Kumar.

In fact I was looking for a formula to locate the first row of the newly
added rata in a range of data. The excel you sent didn’t include any
formula.

Do you have any solution for this.

Fouad

Store Excel in dataTable1.
After adding data store it in dataTable2.
use Mergetable activity.
Destination dataTable1
Source Datatable2
Assign newDatatable dtO= dataTable1.getchanges().

You got your changes.

1 Like

Can you try this:

  1. Read Range activity to read excel in datatable.
  2. Use DataTable.rows.count to get the count of rows.
  3. Use DataTable.row(count-1).item(< column number/column name >) to extract the data of last row.

Hi,
I have attached the xaml file,you can check it may helps you

excelrecentdata.xaml (12.0 KB)
recentexceldata.xlsx (9.7 KB)

and create one text file and store int value at default 0 …

and create one text file and store int value at default 0 …