MarketplaceListingsCustom ActivityEDP - Create Excel Pivot Table

EDP - Create Excel Pivot Table

Silver Certified

Custom Activity

0 reviews

18

EDP - Create Excel Pivot Table

Silver Certified

Custom Activity

0 reviews

18


Summary

Custom activities for creating filterable pivot tables in Excel sheets.

carouselImage0

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.

Benefits

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

Published: 06 Dec 2021 | Updated: 06 Dec 2021


License

MIT


Code Language

C#, Visual Basic


Runtime

Windows Legacy (.Net Framework 4.6.1)


Tags

excel
pivot
table
create
filter

Compatibility

Studio: 2020.10.4+


Dependencies

• Microsoft.Office.Interop.Excel (15.0.4795.1000)


Documentation


Similar Listings