How to delete rows in the same sheet (Excel)?

[prasath17 (Guru)]

@Tana20 - Glad it helped you. Did you already ran this against your 20K rows file?

I had 36K rows file, Filter table taking close 10-15 mins to run(along with the other activities)…Later I changed it to LINQ (after learning thru Forum) my job ran in less than 2 mins.

You refer this post for future filtering queries…

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)< >''"…

Also this

Four Ways to Filter Data Tables in UiPath Studio | UiPath