Remove Row from excel

Help
1

I have like 100 rows in excel sheet and want to remove a specific row based on value
For ex: In column: Status, if i have a Error i want to remove those rows.
Attached screenshot

image

2

1.) Use Read Range to read the data to a datatable.
2.) Use Filter Datatable with the Remove option selected, and set the column to “Status”, the expression to =, and the value to “Error”.
3.) Use Write Range to write the data after filtering.

3

Thanks for the quick reply, I don’t want to write any value. Just want to remove the row.

4

If you overwrite the data to the same workbook, it will only contain only the rows you want and the others will be removed.

5

This is the excel

image
image1467×187 7.22 KB

This is code how i written

image
image1293×455 22.4 KB

Filter

image
image924×569 16 KB

6

Now all you need to do is write the range over the original workbook. To start, write to a new file to validate that everything is working correctly.

7

Hi @Chaitan,

Here is an activity called “Delete Row”. it helps to remover multiple rows.

Regards
Balamurugan.S