Is there any way to cut all rows to the bottom of excel?


We can skip or take the records we want with this method

Dt = Dt.Asenumerable().Take(number of rows in count you want).CopyToDataTable()

If you want to remove last row alone then

Dt = Dt.Asenumerable().Take(dt.rows.count - 1).CopyToDataTable()


If you know the range of data to be extracted dt from a excel then we can mention the range as well while reading the excel with READ RANGE activity

Hope this would help you resolve this