How to Get Recendly added row from excel


#1

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


#2

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


#3

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 …


#4

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


#5

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.


#6

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.

#7

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

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


#8

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


#9

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