How to use delete range

[Chippy_Kolot (CK)]

Hi,
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.

[mkankatala (Mahesh Kankatala)]

Hi @Chippy_Kolot

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

[ushu (Usha kiranmai)]

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

[fernando_zuluaga]

Hi @Chippy_Kolot

Enable classic experience

Then use this small logic

your range should be this

"A2:Z" + dtInput.RowCount.ToString()

Regards!

[ushu (Usha kiranmai)]

@Chippy_Kolot - Check the attached workflow

SampleWorkflow.zip (11.2 KB)

Input

Output