How to remove excel rows have list of emails

Feedback Studio
,
3

Hey @MD_Farhan1
If you have a list of email addresses you can easily do it in UiPath - just read your Excel file into a DataTable, then use a Filter Data Table activity with option remove for each element of list.
You can also use Assign with LINQ to exclude rows where the email column matches any email from your list.
dt1.AsEnumerable().Where(Function(row) Not emailList.Contains(row("Email").ToString)).CopyToDataTable()

A workflow in UiPath Studio filters and processes email data from an Excel file, displaying specific email addresses in the output. (Captioned by AI)
A workflow in UiPath Studio filters and processes email data from an Excel file, displaying specific email addresses in the output. (Captioned by AI)1145×935 36.5 KB

Here, you can find example:
BlankProcess23.zip (146.6 KB)