Create Pivot Table

UiPath.Excel.Activities.ExcelCreatePivotTable

Creates a pivot table from a specified range.

Properties

Common

• DisplayName - The display name of the activity.

Destination

• Range - The range where you want the pivot table to be created. This field supports only strings and String variables.
• Table Name - The name of the pivot table that is to be created. This field supports only strings and String variables.

Input

• SheetName - The name of the sheet you want to create the pivot table from. This field supports only strings and String variables.
• SourceTableName - The name of the source table you want to create the pivot table from. This field supports only strings and String variables.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of Using the Create Pivot Table Activity

To exemplify how to use this activity, we have built an automation project which creates a Pivot Table from an Excel workbook.

Download example