MarketplaceStudioActivityExcel Pivot Table Filter

Create your first automation in just a few minutes.Try Studio Web

Excel Pivot Table Filter

Excel Pivot Table Filter

by Aditi parmar

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

2.1k

back button
back button
next button
next button

Summary

Summary

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

Overview

Overview

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

Features

Features

- 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.

Additional Information

Additional Information

Dependencies

Microsoft.office.interop.excel

Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Aditi parmar

Visit publisher's page

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.0

Updated

May 6, 2020

Works with

Studio: 19.10.4 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings