Delete the row if column has "0"



I am trying to delete the whole row of an excel sheet if column H has “0”. But getting the following error: Collection was modified; enumeration operation might not execute.
I have attached the file. Could anyone help

Pilot_Refresh_MB5B_MB5T.xaml (10.2 KB)


hi @nikhilaramesh08,

use assign activiy"[Total Receipt Qties] <> '0'").CopyToDataTable()



Found the answer: Delete data row from data table


Thanks Arivu