Simulate Click on Excel filter list

[mkkajtez (Miso)]

I have an excel file where I need to select a certain value from a filter. The values are

ONTARIO
ONTARIO - FILE
ALBERTA
ALBERTA - FILE
WEST
WEST - FILE

etc…

There are many values so the filter has a scroll down wheel. If I need to select the very last value for example, how do I do so? I am trying to use simulate click because it shouldn’t need to be on the screen and it fails. If it’s visible on the scroll wheel it works.

[chenderson (Cary Henderson)]

Good morning Mkkajtez,

Do you need to interact with the list in Excel or are you able to use the Read Range activity to extract the datatable and then use the Filter Datatable activity to get the rows you need?

If you need to interact with the filter in Excel, have you considered typing the value into the filter instead of scrolling down?

[martinw3 (Martin Ross)]

Solid advice here. Extracting the data table with Read Range and using the built in Filter Data Table activity in UiPath is the preferred option. The automation should execute much faster than trying to interact with the sheet directly through the Excel UI to get the value you need.