Skip to main content

Create Pivot Table

Creates a pivot table from a specified range or table to help you calculate, summarize, and analyze data

Input​

  • Source sheet name: The Excel sheet to be processed
    • Type: System.String
    • Required
  • Destination Sheet Name: Where to place the new pivot table
    • Type: System.String
    • Required
  • First Destination Cell: The first cell on the destination sheet to add the pivot table to (Default is "A1")
    • Type: System.String
  • New Table Name: Name of the new pivot table
    • Type: System.String
    • Required

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.
  • Click the "Add Pivot Table Field" button to add a pivot table field.
  • A "Pivot Table Field" activity will be added in the design area, and you can add a pivot table field using this activity.

Add Pivot Table Field​

Adds a pivot table field.

Input​

  • Field: Name of the pivot table field
    • Type: System.String
    • Required
  • Is a: Type of the field
    • Type: System.Int32
    • Required
    • Dropdown Options:
      • Row
      • Column
      • Filter
      • Value
  • Function: If the field is selected as a value, specifies that the function will be applied to this field.
    • Type: System.Int32
    • Dropdown Options:
      • Sum
      • Count
      • Average
      • Max
      • Min
      • Product
      • CountNumbers
      • StDev
      • StDevP
      • Var
      • VarP