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

[lrtetala (Lakshman Reddy)]

Hi @Nur.ain

How about the following?

(From row In DT.AsEnumerable()
          Where Not String.IsNullOrEmpty(row.ItemArray(1).ToString())
          Select row).CopyToDataTable()

I/P:

O/P:

Hope this helps!!