I have an excel column names are fixed but rows can vary depends up on the data…How can I use delete range activity. Range what I can provide, I want headers to remain the same.
To delete the specific rows from the excel file you can use the “Delete Rows” activity to delete the specific rows. This activity has to be used inside the excel process scope and use excel file activity.
Hope it helps!!
Hi @Chippy_Kolot - First, read the excel data to data table, pass the data table rows count in the range field of Delete Range activity
Enable classic experience
Then use this small logic
your range should be this
"A2:Z" + dtInput.RowCount.ToString()
@Chippy_Kolot - Check the attached workflow
SampleWorkflow.zip (11.2 KB)