Delete Excel rows

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

There is simple technique in Studiox to achieve your requirement. Please follow the below steps.

1. Use excel file to choose your excel.

2. Inside Use excel activity. Use filter activity to select your column name in our case balance and assign basic filter like is equal to “0”

3. Now use the delete rows activity and select the option Delete all visible rows.
   now it is have ability to delete all rows with zero in the balance column at single shot.

4. Use filter activity to again but this time only select clear any existing filter check box to see our final output in the excel.

please refer the below screenshot and also i am attaching the sample work flow. take a look and try and let us know. thanks.

DeleteRowsDemo.zip (59.6 KB)