Settings for FilterX Activity

[gorby (RPA Ninja)]

Hello
I am using StudioX 2024.10.14 LTS.

1. What I want to do

I want to place the ExcelApplicationCard inside the ForEachFileX activity, and inside it, place the FilterX activity to filter the apple column in the Excel sheet.

2. What I am struggling with

I thought that the filter would be applied to the sheet, but it seems that there is no option in the FilterX activity to specify the sheet, and it looks like the filter is being applied to the currently opened Excel file, CurrentFile. Is my understanding correct?

[ashokkarale]

@gorby

We don’t have Sheet option. We will have to specify the Sheet in the Source Range like this