Linq QueryRelated

[Krishna_Raj]

@Rahul_Maddy

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

check the reference thread