Delete of excel rows when cells in a specific column are empty

[Krishna_Raj]

@Mazis_Georgios

How to delete entire row in excel if the specific column is empty

Hi @Nur.ain How about the following? [image] (From row In DT.AsEnumerable() Where Not String.IsNullOrEmpty(row.ItemArray(1).ToString()) Select row).CopyToDataTable() I/P: [image] O/P: [image] Hope this helps!!

check the reference