How to delete a row in an Excel workbook

[jmf (Jawaad Farooqui)]

Badita, because "For Each " loop doesnt allow Remove Data row , I used "do while loop "
click the blue link below

How to Delete or Remove Data Row using a WHILE LOOP

FOR EACH LOOP does not allow Remove Datarow Activity during it’s iterations. You can use datatable.select to filter if you want but if you want a simpler but extremely powerful method use this. The reason this is powerful is that you can put as many conditions on as many columns as you want. It’s powerful because of simplicity but performance wise it is not the best with Uipath. The source of datatable may be an excel or may be a CSV Test the Algorithm for performance if your input file is mor…