Read header and last updated row from excel using workbook

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.

Suresh J


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 (19.3 KB)