How to filter with some values in a column

Help Automation Ops
,
2

You can read the data of an excel with the help of UiPath Excel activities (Read range activity under Excel application scope). Take the output in a variable which will be of type Datatable. Then filter the data of a column as you want. Filter can be done by below 2 ways.

  1. Use the filter activity of UiPath. Provide the column name on which u want to put filter and the value it should contain e.g Column A should be filter with value contain XXXX.
  2. Use LINQ query. Like YouDataTable.Aseneumberable(). where(Function(x) x.item(“ColumnName”).tostring.Equals(“Value”)).CopyTodataTable.