Hello, I need to search for every “ADP” cell, and if the float number are < 20 delete the row.
I have a lot of difficulty with excel, I would be grateful if you could give me a little help 
Hi @igorpicoli,
Create a variable as rowsToRemove with List(Of DataRow) datatype
then in an assign activity place the below code
= table.AsEnumerable().Where(Function(r) (r.Field(Of Integer)(“ADP”))<20).ToList()
Then in a for each loop with Type Argument as “DataRow”,
place a remove datarow activity and pass the item as the “Row” value and table as the datatable name.
Finally write this into the excel sheet as you want.
1 Like