Create Pivot Table ​

Function Description ​

TIP

Create a pivot table from the specified range

Create Pivot Table

Configuration Item Description ​

General ​

Command Input

  • Excel InstanceTWorkbookApplication: Enter an Excel instance obtained through the function 'Open or New Excel'/'Get currently active Excel object'

  • Rangestring: Specify the location range for creating the pivot table

  • Table Namestring: The name of the data pivot table to be created

  • Sheet Namestring: The name of the worksheet in the workbook

  • Source Table Namestring: The name of the source table from which to create the pivot table

  • Source Rangestring: The source data range from which you want to create the pivot table

Command Output

No output for the current command

Advanced ​

  • Delay Before(milliseconds)Integer: The waiting time before instruction execution

Error Handling ​

  • Print Error LogsBoolean: Whether to print error logs to the "Logs" panel when the command fails. Default is checked.

  • Handling MethodInteger:

    • Terminate Process: If the command fails, terminate the process.

    • Ignore Exception and Continue Execution: If the command fails, ignore the exception and continue the process.

    • Retry This Command: If the command fails, retry the command a specified number of times with a specified interval between retries.

Usage Example ​

Process logic description:

Common Errors and Handling ​

None

Frequently Asked Questions ​

None