Remove filters from excel file

Help Activities
, , , ,
1

I have an excel in which I must collect all the data but this excel sometimes comes with filters applied, also when collecting the information with the “Read Range” activity does it read the data even if it does not appear in that list visually?

Thankssss! :slight_smile:

1 Like
2

Hi @Nicollebro ,
Read range have property
You can select if have filter
image
“Use Filter”
image
regards,

1 Like
3

Read range reads all data by default (of the selected range) , regardless of filter.
There is an option: use filters which will allow you to respect the potentially active filters.

1 Like
4

@Nicollebro

Read Range works with Filter applied sheets but it will not work for Write Range.

For write range you have to remove filter first.

1 Like
5

Hi

Welcome to UiPath forum

Usually when you read from READ RANGE it doesn’t take the filter applied in excel
It reads the complete records

For reference from UiPath docs

IMG_8361
IMG_8361828×269 49.1 KB

Hope this clarifies

Cheers @Nicollebro

1 Like
6

Hello @Nicollebro ,
You can clear the filter using Excel Moder activities and can read using it.
Use Filter activity and enable the Clear any Existing Filter option

image
image805×714 26.6 KB

If you are a Classic user, try this to access Modern activity.

  • In activity pannel Click Filter Option.
  • Enable the Modern Option
  • Now can search for Moden excel activities
    image
1 Like
7

@Nicollebro

Read range in excel activitues has an option to use filters if needed cna use it else it will read all the data

Alternately read range workbook can be used

Cheers

1 Like
8

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