a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

2074b0a7-1216-4563-b5d5-13719766f626.nupkg

b0a686df-1960-43a9-a7b1-f2e9f9fb5bf2.png

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.

Creates pivot table with specific pivot fields.

4e4b9946-698a-4416-883f-a88d391874f7.png

f0341b72-7f2a-484d-a45e-e01adb2c93de.png

Visual Basic

f289eba9-280e-4684-89d4-faabeb28c4c5.zip

02aec40f-465a-4d58-a124-885f653dc49d.nupkg

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

Version	Release Date	Download Link
1.0.2	January 23, 2023
Second Version Compatible with .net framework v.4.6.1 and .net v6.0
1.0.0	December 8, 2021
First Version

Create Pivot Table with Specific Pivot Fields