Subscribe

UiPath Activities

The UiPath Activities Guide

Change Pivot Data Source

UiPath.Excel.Activities.Business.ChangePivotDataSourceX

Changes the range of the source data for a specified pivot table. You can use this activity if the source range has been modified by adding or removing rows. If the source data has changed substantially, for example columns have been added or removed, you should create a new pivot table instead. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

  • Pivot table - Click Plus plus buttonplus button on the right side of the field, then select the Excel file and the name of the original pivot table. or select Indicate in Excel to open the file and indicate a cell from the pivot table. Alternatively, you can select Custom Input to enter the pivot table name manually, or Open in Advanced Editor to enter a VB expression.
  • New source - Click Plus plus buttonplus button 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 to use as the source of the pivot table, or select Indicate in Excel to indicate a range directly from the file. If you want to select an entire sheet, select Indicate in Excel, and then select all the columns you need (for example: A:F). Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.

In the Properties Panel

Common

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

Input

Misc

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

Updated 29 days ago


Change Pivot Data Source


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.