Deleting all data rows below certain data row

Help Studio
1

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!

2

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

Regards

3

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.