Excel clear all filters

Help Studio
1

How do I clear all filters from an excel table?

In this activity the column name is mandatory but I want to remove filter from all columns be it any.

Please advice.

Also what to put in the source range, because I have a dynamic source file without fix range.

image
image370×228 10 KB

2

Hello @tejaskumar.darji

Please refer How to Remove Excel Filters using UiPath? - #6 by supermanPunch

In Range - Excel.sheet(“sheetname”)

3

Hello , I did check the other thread but in the latest excel package the column name is a mandatory field, that is why I had to raise this query here. That thread is on older package version.

4

Hi @tejaskumar.darji

I would try with this setup.
(Need to be real column in your file).

image
image630×788 28.9 KB

Regards
Soren

5

Yeah, that’s exactly the issue - I want to clear filters from all columns, but I don’t know which specific ones have filters applied. There are around 40 columns, and filters could be active on multiple columns.

6

Hi @tejaskumar.darji,

It should work after enabling the Clear any existing filter option.

image

Thanks

7

Do you know just one of the columns?
Then try and see what happens - perhaps all existing filters are cleaned.