Articles → UiPath → Create Pivot Table Activity In Uipath

Create Pivot Table Activity In Uipath


Excel File

Picture showing the data in excel for pivot table creation
Click to Enlarge

  1. Select the table i.e., A1: B8
  2. Go to "Insert" → "Table". A pop-up window will appear
  3. Picture showing converting the range into the table in excel
    Click to Enlarge

  4. Click on the "OK" button
  5. A table is created
  6. Picture showing the name of the table of the given range in excel
    Click to Enlarge

  7. Save and close the Excel file


  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
  3. Picture showing the Create Pivot Table activity inside the Excel Application Scope
    Click to Enlarge

  4. 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
  5. Save the file and run the bot


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


Your Email Id  
Query/FeedbackCharacters remaining 250