How to delete row in Excel

[nick.v (nic)]

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

[balupad14 (Balamurugan)]

How to search for data in Excel

Hi @nick.v, To search the data inside excel, you can use the “Find” activity which is in the below. It returns the cellinfo and rowindex. https://forum.uipath.com/t/uipath-go-balareva-easyexcel-activities/166961/10?u=balupad14 Video explanation : [Uipath Excel Find | Search | Find and Replace (BalaReva)] Delete the row. https://forum.uipath.com/t/uipath-go-balareva-easyexcel-activities/166961/16?u=balupad14 [Uipath | excel delete rows | excel delete columns | excel co…

[Pratik_Wavhal]

Hi @nick.v

Below is the workflow which will give the idea.
Remove DataRow on Condition.zip (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

Happy Automation

Best Regards
Er Pratik Wavhal