How to filter columns in excel sheet

Help Activities
, ,
1

image
image1400×104 26.8 KB

I need to filter Status column, Exception column, and started column.
Which activity suitable for this automation ?
Please help.

2

you can use Read the file and then use Filter Datatable Activity to put your desired filters

3

@Uipatther

  1. Use Read Range activity to read the data from excel file and it will give output as DataTable.

  2. And then you use Filter DataTable activity or Select Query or LINQ query to filter the data from DataTable to get desired rows from it.