Studio does not recognise Excel filter

Help Activities
, ,
1

Hello guys, I have been having some issues while working with some Excel tables. If the Excel have some filters active, the Studio continues to read the areas that are not selected by the filter. Is this normal?, or it is needed to set also a filter on the Studio to recognize the existing filter on the Excel sheet?

Thanks in advance.

3

What activity are you using to read data from Excel?

4

I have a sequence that:
1 - Reads the file from the WorkbookPath
2 - Then I use a “Get Workbook Sheet”
3 - Read Range
4 - For Each Row
5 - I assign the variables to the row items (Ex.: assign town = row. Item(“Town Name”.ToString)

5

The Read Range activity has a checkbox in properties: UseFilter. Check this box and it will select the correct data.

image

3 Likes
6

Thanks!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.