How to delete row in Excel

Hi Guys,

I am looking to read a excel doc and then delete rows that don’t have the word ‘UiPath’ in Column A.
Below is a snap shot of the document.

This would include deleting the rows in black.

Not sure how i can go about doing this, any help would be greatly appreciated

Hi @nick.v

Below is the workflow which will give the idea.
Remove DataRow on (34.7 KB)

Just make changes as per into the below Statement in the workflow

datatable.Select("[columnName] = 'ValueToSearch'") 

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: