MarketplaceListingsCustom ActivityFPT Software - Remove Auto Filter

FPT Software - Remove Auto Filter

Bronze Certified

Custom Activity

0 reviews

184

FPT Software - Remove Auto Filter

Bronze Certified

Custom Activity

0 reviews

184


Summary

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

carouselImage0

Overview

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

Benefits


Published: 23 Sep 2020 | Updated: 18 Dec 2020


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Framework


Tags

excel
#Excel Filter
remove filter

Compatibility

Studio: 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]"


Documentation


Similar Listings