Delete Specific Range in excel STUDIO

I need to delete all the rows that are filled in the Sheet except the hearder, how can I define that range A2: … ?
Is there an expression to select a range from a specific cell to the last cell that is filled ?
Thank you

use clear table activity for clear all data except headers


We can try like this:

Dt = Dt.Clone()

This will give you the headers…


We can use clear data table activity to clear the entire data except headers


Hi @mihai.godeanu

I have found a part of solution here and added something bits with it to solve your specific problem.

Delete Specific Range in excel STUDIO.xaml (9.8 KB)

I hope this helps you.