MarketplaceListingsCustom ActivityCreate Pivot Table with Specific Pivot Fields

Create Pivot Table with Specific Pivot Fields

by Internal Labs

0

248

Create Pivot Table with Specific Pivot Fields

by Internal Labs

0

Custom Activity

248

carouselImage0

Summary

Summary


Overview

Overview

This package has been created to create pivot table with specific pivot fields from the data source.

Mandatory input fields :
  • Workbook File Path - This activity works on a single file and it must contain your data source for pivot in the same file.
  • Data Source Sheet Name (where data source is available) & Input Data Source Range.
  • Destination Sheet Name (where pivot table will be created).
Optional Fields
  • Destination Data Source Range, Row Pivot Fields, Column Pivot Fields & Data Pivot Fields. Multiple pivot fields can be added as comma ',' separated values.
Notes:
  • At least one of the pivot field argument must be filled.
  • If the destination sheet name does not exist in the Excel, it will create it.
  • If destination data source range is not provided, it will consider the range as "A1".
  • Before using the activity, the Excel file should be closed.
  • The activity will load the file and process the activity in the background.
  • Excel file name must be mentioned in absolute path.

Features

Features

For Excel users, this activity helps in creating a pivot table based on specific pivot fields from the data source as per the business requirment.
Since this activity runs in background with a runtime of less than a minute, it eliminates the need for engaging in UI interaction or macro to create a pivot table with specific number and type of pivot fields.

Additional Information

Additional Information

Dependencies


Code Language

C#, Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Internal Labs

Visit Publisher's Page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.0

Updated

08 Dec 2021

Certification

Silver Certified

Tags

pivot fields

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings