Delete Specific Range in excel STUDIO

Help Activities
, , , , ,
1

Hello,
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

2

use clear table activity for clear all data except headers

3

Hey!

We can try like this:

Dt = Dt.Clone()

This will give you the headers…

OR

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

Regards,
NaNi

4

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.
Cheers