Copy Specific Excel Data to Another Worksheet?

[unknownay]

@Luecke_Anthony

Basically you need to remove last 2 rows of your datatable. use below code to do that
dt.AsEnumerable.Take(dt.Rows.Count -2).CopyToDataTable

If you get any error on asenumerable function. refere below link

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

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Regards
Roshan