Excel Create Pivot Table

Description

This action component allows you to create a pivot table from a specified range.

Input Properties

• Input ExcelObject (IExcelObject) – The input Excel Object connection.
• Source Table Name (String) – The name of the source table you want to create the pivot table from.
• Sheet Name (String) – The name of the sheet you want to create the pivot table.
• Cell Name (String) – The cell name.
• Source Sheet Name (String) – The name of the sheet you want to create the pivot table from.
• Range Name (String) – The range where you want the pivot table to be created.
• Table Name (String) – The name of the pivot table that is to be created.

General Properties

• Global Waits (Checkbox) – Apply global waits when PreWait or PostWait are not specified.
• Ignore Error (Checkbox) – Continue the process flow without throwing error.
• Post Wait (Checkbox) – Apply specified wait after execute the action.
• Pre Wait (Checkbox) – Apply specified wait before execute the action.