How to delete row in excel with condition


I have an excel like below, i want to remove the data with condition status =PH and Type=1

i want the output is the original excel file with the removed data as stated, without rewrite into new sheet.

May i know how to do it.



Hi @ireneqir
New Dt=Dt.Select("[Status=‘PH’] and[Type=‘1’]").CopyToDatatable()

Check it
for each row in datatable
use remove data row

Ashwin S

do you have example? where to write the code? sorry im very new to it