MarketplaceListingsCustom ActivityFPT Software - Remove Auto Filter

FPT Software - Remove Auto Filter

Bronze Certified

Custom Activity

0 reviews

168

FPT Software - Remove Auto Filter

Bronze Certified

Custom Activity

0 reviews

168


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: 2020-09-23T11:12:34+00:00 | Updated: 2020-12-18T00:00:09+00:00


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Tags

excel
#Excel Filter
remove filter

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


Documentation


Similar Listings