Articles → UiPath → Create Pivot Table Activity In Uipath

Create Pivot Table Activity In Uipath

Purpose

Excel File

1. Select the table i.e. A1: B8.
2. Go to "Insert" → "Table". A pop up window will appear.


Click to Enlarge


3. Click on the "Ok" button.
4. A table is created.


Click to Enlarge


5. Save and close the excel file.

Example

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.


Click to Enlarge


3. Inside the "Create Pivot Table" activity
   1. "Sheet1" as sheet name.
   2. "E1" is the starting point from where the pivot will be created.
   3. "Table1" is the table name of the excel.
   4. "PTable" is the pivot table name.
4. Save the file and run the bot.

Output