How to delete Empty Rows in Excel

[Palaniyappan (Palaniyappan P)]

@Palaniyappan

yourdatatable = yourdatatable.Select("[yourcolumnname] <> string.Empty ").CopyToDatatable()

may i know the datatype of that column
this would work actually
for more details on ths

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Cheers @Pradeep_Shiv