Connect HomeMarketplaceComponentsExcel Pivot Table Filter

Excel Pivot Table Filter

Custom Activity

Custom Activity

Updated: October 21st, 2020

Published: April 21st, 2020

Downloads: 38

Industry: Utilities

Language compatibility: Visual Basic

Community Support

Excel Pivot Table Filter

Custom Activity

Summary: 

By using this activity we can filter the pivot table in an Excel application

In this activity the following parameters are required:
  1. Excel file path
  2. Sheet name
  3. Pivot table name - Enter the pivot table name
  4. Column Name - Define the column in which you want to apply the filter
  5. Value - by which you want to filter the column in the pivot Table

Details

Benefits

- With the use this custom activity we can easily apply the filter on pivot table in a close or open application. Currently it works only with open because the set visibility is true.
- This activity can work without Excel scope.

Compatibility

it will work with UiPath Studio 2019.10.4

Dependencies

Microsoft.office.interop.excel

Licensing

By clicking download you agree to the following license.