Deleting empty records in empty records in excel


Hi ,
I have a problem of deleting empty records in excel, as if all the records are empty i can delete but in this scemario the first column has ''S.NO" data but the records are empty .so, i want to delete the empty records in excel EXCELFILE1.xlsx (465.3 KB)
please find the attachment

Thanks in advance


Hi @skrishna,

you can use below code to get non empty records alone.


dt.Rows.Cast(Of DataRow)().Where(Function(row) Not row("Column3").Equals("")).CopyToDataTable()



Hi @skrishna,

i have modified from your code, please use below xaml file.

DT1.Select("Convert(column3, System.String)< >''").CopyToDataTable()

sol.xaml (8.8 KB)


Create a folder by its file name