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