Help with excel

Hello, I need to search for every “ADP” cell, and if the float number are < 20 delete the row.

image

I have a lot of difficulty with excel, I would be grateful if you could give me a little help :slight_smile:

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.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