UiPath.Excel.Activities.Business.CreatePivotTableX

Creates a pivot table from a specified range or table to help you calculate, summarize, and analyze data. Once added, you can add pivot table fields as rows, columns, filters, or summary fields.

To learn how to use this activity, see Tutorial: Creating a Pivot Table.

In the Body of the Activity

• Source range - Click on the right side of the field and then, from the menu, select the Excel file and then either select a named range or table from the file, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
• New table name - Click on the right side of the field and then, from the menu, select a name for the table using one of the available options:
  • Data from an application added to a card in the project or from the Excel Workspace, for example a cell in an Excel file, or a field in a selected Outlook email.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter the name using the Text Builder.
  • Open in Advanced Editor - Enter a VB expression.
• Destination range - Click on the right side of the field and then, from the menu, select an Excel file and then a table or sheet where to create the pivot table, or select Indicate in Excel to indicate directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
• Add Pivot Table Field - Click this button to add a pivot table field.

Pivot Field Options

• Field - Click on the right side of the field and then, from the menu, select Range and a column header, or select an Excel file and then Indicate in Excel to indicate a column header in the file. Alternatively, you can select Text and enter the column name as text, or select Open in Advanced Editor and enter a VB expression.
• Is a - Select what the field should be in the pivot table: Row, Column, Filter, or Value.
• Function - If the field is a value,select what function should be used: Sum, Count, Average, Max, Min, Product, CountNumbers, StdDev, StdDevp, Var, Varp.

Properties

Common

• Display Name - The name displayed for the activity in the Designer panel.

Input

• Destination range - See Destination range in the body of the activity
• New table Name - See New table name in the body of the activity.
• Table range - See Source range in the body of the activity.
• Values added as - Select how to add the values in the pivot table, either as columns (the default option) or rows.

Misc

• Private - If selected, the data used in the activity is not logged by StudioX.