Articles → UiPath → Create Pivot Table activity in Uipath

Create Pivot Table activity in Uipath

In this article, we will discuss "Create Pivot Table" activity in Uipath.

Purpose

The "Create Pivot Table" activity creates a pivot table.

Excel file

Consider the following excel file.

Picture showing the data in excel for pivot table creation

Click to Enlarge

We will create the pivot table for this range. Before doing that, convert this range to the table. To do that.

1. Select the table i.e. A1: B8.

2. Go to "Insert" → "Table". A pop up window will appear.

Picture showing converting the range into the table in excel

Click to Enlarge

3. Click on the "Ok" button.

4. A table is created.

Picture showing the name of the table of the given range in excel

Click to Enlarge

5. Save and close the excel file.

Example

In this example, we will follow these steps.

1. Drag and drop the "Excel Application Scope" activity and mention the excel file name.

2. Inside the "Excel Application Scope" activity, drag and drop the "Create Pivot Table" activity.

Picture showing the Create Pivot Table activity inside the Excel Application Scope

Click to Enlarge

      3. Inside the "Create Pivot Table" activity

            a. "Sheet1" as sheet name.

            b. "E1" is the starting point from where the pivot will be created.

            c. "Table1" is the table name of the excel.

            d. "PTable" is the pivot table name.

      4. Save the file and run the bot.

Output

Picture showing the pivot table created from the Create Pivot Table activity

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, January 22, 2021

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250