How to Discard the row which has blank columns

Hi @Chirag12 ,

From a Datatable manipulation point of view or assuming you have read the excel sheet as a Datatable, you can check with the below Expression :

DT = DT.AsEnumerable.Where(Function(x)x.ItemArray.All(Function(y)Not String.IsNullOrWhiteSpace(y.ToString))).CopyToDatatable

For handling errors on Direct CopyToDatatable, you can check the below :

2 Likes