Articles → UiPath → Create Pivot Table Activity In Uipath

Create Pivot Table Activity In Uipath






Purpose





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.

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.
  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.

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/FeedbackCharacters remaining 250