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 ?
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