How to read only the header and last updated row(full row with 7 columns) from excel.
Using Read Range activity Read the Excel, mention the Range as “” this will read the used range of the Excel.
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)