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.

Create Pivot Table with Specific Pivot Fields