How to delete row in excel with condition

Help
1

Hi,

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.

thanks

image

2

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

Check it
for each row in datatable
use remove data row

Thanks
Ashwin S

3

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