How to Remove Excel Filters using UiPath?

Help Studio
1

Hello All,
Please help on my new Project .
I want to remove Excel filters and add the same later.
How to do that ?

2

Hello @subhash1
Use Modern excel activity
If you are using classic, just follow the below steps to use modern activity

  1. Click the Filter option on Activity pannel.
  2. Enable the Show modern option
    image
  3. Search Excel.
  4. Place Excel process scope, within it place the Use Excel file.
  5. In which place the filter activity(pass the source range), check on the clear any existing filter
    image
    image666Ă—636 17.8 KB
3

Hi @Gokul_Jayakumar
After some calculations i need to apply again the filters.
So please make logic accordingly.

4

@Gokul_Jayakumar it is not working. And what do i need to mention in the “Colum name” . I want to remove for overall sheet.

5

Hi @subhash1 ,

We can use simple vb code to enable and disable filter in the excel sheet.

To use the vb code to perform the operation we can utilise the invoke code activity in UiPath and choose the vb.net as programming language.

Vb have method called enable auto filter which we have to set it to on and off to perform the above.

For starter help please refer the below link

Please try the above options and let me know if you need any more help. Thanks

Regards,
Kirankumar.

6

Hi @subhash1 ,

For Removing the Filters in the Excel Sheet, we could go for Modern Excel Activities Filter Activity Specify the Source as Sheet name and Check Clear any Existing Filters like below :
image

However, we will lose the applied Filters and not so sure if we could get the applied filters back unless we know the Filters ourselves.

If we do know the Filters that is to be applied, we could make use of the same Filter Activity to apply the Filters to the Columns needed like below :

image
image1021Ă—441 19.6 KB

If multiple Filters needed to be applied on multiple columns, we would need to use Multiple Filter Activities.

Let us know if this doesn’t help.

1 Like