Filter Blank rows in Excel using Linq

Hello @Manii_K

Get data to a data table say dt_new
Posted Use this query: dt_new.AsEnumerable.Where(Function(x) Not String.IsNullOrWhiteSpace(x(“Posted”).ToString)).CopyToDataTable

Not Posted : dt_new.AsEnumerable.Where(Function(x) String.IsNullOrWhiteSpace(x(“Posted”).ToString)).CopyToDataTable

Thank You