Deleting all data rows below certain data row

Hi! , i was wondering if anyone know how to remove all the datarows below certain row, i need to extract information from an excel file to a certain point where the cell is empty, but below that empty cell there is more information that i dont want to extract.

so i need to find a way to if the cell is empty remove all rows below.

Ty for taking your time in replying!

Did you try with delete row activity passing the index of the row you need?


I would just For Each Row through it and add each row to a new DT until you get to the blank cell then stop.