Filter columns in excel

Help StudioX
, , ,
1

Hello!

I am asking you for help - how filter columns in Excel, in UiPath StudioX? I have two columns to filter.
I’m a beginner, please give details.

2

Hi @sullivanne

The following resource might help you with this:

https://docs.uipath.com/studiox/standalone/2023.4/user-guide/tutorial-filtering-data-in-excel

Best Regards.

3
  1. Below are the sequence of steps to follow.
    image
    image452×679 21.7 KB
  2. Write the below required conditions under Filter Datatable activity. Refer the image below.
    image
    image692×476 14.7 KB
  3. Use Write DataTable to Excel undwer filter datatable to write the output columns to excel.
    image

If you need further guidance please share your input excel and columns to be filtered. I will get back to you with solution.

Hope it helps!!
Regards,

4

@sullivanne

Use Two excel filter activities one after the other for each column you need to filter

cheers