Delete the rows

[Hemant_Deshmukh]

I have excel file in which i paste some rows(rows numbers not fixed) like “A” given in image after that i get result like “C” in image…but i want to delete all remaining rows between A and c .which given as B in image .deleting numbers are not fix…so how to automate plz help. in “delete rows” activity they are asking for specific range like 3-5,4-9 etc.

[iamNairda (Adrian)]

I assume you are using a “For Each Row” Loop?
You can use a Filter DT before or after “For Each Row” or a “Remove Data Row” if you want to do it in the loop. To find the empty rows you can use an if condition.

…or check this video:

UiPath | Remove Empty Rows From DataTable #2 | How to remove empty rows from Data Table with Filter

[Shiva_Nikhil]

@Hemant_Deshmukh

you can read the excel and later you can use query to remove the empty rows

[lrtetala (Lakshman Reddy)]

Hi @Hemant_Deshmukh

Use Filter Data Table activity

Hope this helps!!