Read header and last updated row from excel using workbook

[RachelN (Rachel)]

How to read only the header and last updated row(full row with 7 columns) from excel.

[sureshj (suresh_hserus)]

@RachelN

Using Read Range activity Read the Excel, mention the Range as “” this will read the used range of the Excel.

Thanks,
Suresh J

[Natapong (Natapong Raojutitam)]

@RachelN

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

Get last row of DataTable

@hansgeeroms Try this query new_DT = DT_input.asenumerable.reverse().take(1).copytodatatable

*Need to adding the Assembly Reference manually in your xaml file for using this command.

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

You can refer to attach file for guideline
ReadLastRow.zip (19.3 KB)