Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

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.

  • Properties
  • Example of Using the Create Pivot Table Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.