Excel sheet in uipath studio

[vimal]

i have two columns of data in excel in which i have to filter the one column using the another column of data

[Sanjit_Pal]

Hey @vimal ,

You can use the Read Range activity to read the datatable and then use Filter Datatable activity and put the ColumnName in the left side and the value to filter at the right side, this way you will get the required output.

Thanks,
Sanjit

[Nitya1 (Nitya Tomar)]

Hi @vimal

To filter one column of data using another column in UiPath, you can use the following steps:

1. Use the “Excel Application Scope” activity to open the Excel file that contains the data.
2. Use the “Read Range” activity to read the data from the Excel file and store it in a DataTable variable.
3. Use the “Filter DataTable” activity to filter the DataTable based on the values in the other column.
4. In the “Filter DataTable” activity, set the “Input” property to the DataTable variable you created in step 2.
5. Set the “Output” property to a new DataTable variable that will hold the filtered data.
6. In the “Filter Wizard”, select the column you want to filter by and the criteria you want to use.
7. Click “OK” to apply the filter.
8. Use the “Write Range” activity to write the filtered data back to the Excel file.
9. Close the Excel file using the “Close Workbook” activity.