Connect HomeMarketplaceComponentsFPT Software - Remove Auto Filter

FPT Software - Remove Auto Filter

Custom Activity

Custom Activity

Updated: September 23rd, 2020

Published: August 15th, 2020

Downloads: 1

Industry: cross-industry

Language compatibility: Visual Basic

Community Support

FPT Software - Remove Auto Filter

Custom Activity


This component is used to remove the filters from an Excel file

This component uses VB.Net to open an Excel file then remove the filters.

There are many ways to do the same operation but VB.Net is more stable than using hotkey or Click activity to work with Excel application.

  • ````In argument:
  1. in_FilePath (String): Excel file path
  2. in_SheetName (String): Excel file name
  3. in_Mode (String): there are 2 modes:
- KeepAutoFilter: Remove all filter conditions but keep filter function on.
- RemoveAutoFilter: Remove filter function



- Excel application scope may not work efficiently with filter.
- Remove filter before processing an Excel file.
- A fast and efficient way to clear filters from an Excel file


Tested on UiPath 2020.4


"Microsoft.Office.Interop.Excel": "[]",
    "UiPath.Excel.Activities": "[2.8.6]",
    "UiPath.Mail.Activities": "[1.8.6]",
    "UiPath.System.Activities": "[20.4.0]",
    "UiPath.UIAutomation.Activities": "[20.4.2]"


- Test Document.pdf


By clicking download you agree to the following license.