Use read range for get data from excel and put in to datatable
and then using below command to get fillter data in data table
new_DT = DT_input.asenumerable.reverse().take(1).copytodatatable
*Need to adding the Assembly Reference manually in your xaml file for using this command.
You can refer to attach file for guideline
ReadLastRow.zip (19.3 KB)