MarketplaceStudioActivityEDP - Create Excel Pivot Table

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

EDP - Create Excel Pivot Table

EDP - Create Excel Pivot Table

by Edp Global Solutions - Gestão Integrada de Serviços S.A

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

134

back button
back button
carouselImage0
next button
next button

Summary

Summary

Custom activities for creating filterable pivot tables in Excel sheets.

Overview

Overview

This package contains the following activities:

  • Create Pivot table - Main activity to create pivot table.
  • Create Pivot Row Item - Instantiates an object to define a pivot row item on the Excel pivot table.
  • Create Pivot Data Item - Instantiates an object to define a pivot column item and its sumarization function for the pivot.
  • Create Pivot Filter Item - Instantiates an object to define a pivot filter item with the values filter out/in of the pivot table.

Features

Features

  • Allows the automation developer to automate the creation of pivot tables form a custom range in an Excel file.
  • Has auxiliary activities for easy definition of the columns and data to be used in the pivot table.
  • Allows defining the columns and values for the rows and columns of the pivot table.
  • Allows defining the columns and values to be filtered out/in of the pivot data.

Additional Information

Additional Information

Dependencies

• Microsoft.Office.Interop.Excel (15.0.4795.1000)

Code Language

C#, Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Edp Global Solutions - Gestão Integrada de Serviços S.A

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.2

Updated

February 16, 2022

Works with

Studio: 20.10.4 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings