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

Summary: 

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

Details

Benefits

- 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

Compatibility

Tested on UiPath 2020.4

Dependencies

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

Resources

- Test Document.pdf

Licensing

By clicking download you agree to the following license.