How to delete entire row in excel if the specific column is empty

[Palaniyappan (Palaniyappan P)]

Welcome back to forum

Have a view on these threads where similar discussion happened earlier with solutions mentioned

How to delete entire Row if a specific column has empty cells

Hi @Tarif_Mohammad , As you have already tried with Filter Datatable Activity and Couldn’t Get the Expected Output, We can Give a Try on Linq Operations. Assuming that you already read the excel sheet using Read Range Activity and Get the Output as Datatable. We can filter the Datatable to Keep only the Rows needed as per your Requirement . Let’s Say we have Datatable variable, DT, Then we can use the Below Linq Expression in an Assign Activity: rowArray = DT.AsEnumerable.Where(Function(x)N…

Remove Empty Rows From DataTable

Hi @Joshikumarav, Use this code DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Refer below link for more information. Regards, Arivu

Hope this helps

Cheers @Nur.ain