Delete row in excel in value in column = 0

Hi @fairymemay

Please refer to the attached Screen Shot below!

Expression

readDt.AsEnumerable().Where(Function(row) Not(row(“Amount”).ToString.Equals(“0”))).CopyToDataTable

Result

image

Regards

1 Like