Deleting empty records in empty records in excel


#1

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


#2

Hi @skrishna,

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

dt.Select("Column3<>''").CopyToDataTable()

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

Regards,
Arivu


#3

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)

Regards,
Arivu


Create a folder by its file name