This article describes the RPA Excel functionality to create a pivot table from a data range.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Add pivot table function creates a pivot table from a data range. Windows only – macOS does not support pivot table creation via COM. The destination can be a cell on the current sheet or a new sheet (prefix with 'sheet:').

Setting it up

To use the EXCEL Add pivot table function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL Add pivot table function
Click on the green button's drop-down (right side of the green button labelled "Process")
On the menu that appears, click on the "+ Activity" item
From here you can select the EXCEL Add pivot table option
Click "Add" once you are done

Input parameters

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the sheet containing the source data.
Source data range	Yes	Text	–	Source data range (e.g. A1:D100). Defaults to the used range.
Pivot table name	Yes	Text	–	Name for the pivot table.
Destination	Yes	Text	–	Destination cell (e.g. G1) or 'sheet:NewSheetName' to create on a new sheet.

Output variables

This action does not produce any output variables.

Errors

Error	Description
File not open	The Excel file must be open.
Sheet not found	The specified sheet does not exist.
Invalid range	The source data range is not valid.
Not supported	Pivot table creation is only supported on Windows.

Tips

This function is Windows only – macOS does not support pivot table creation via COM.
Use 'sheet:PivotSheet' as the destination to place the pivot table on a new sheet.
Use the Remove pivot table function to delete pivot tables.

EXCEL Add pivot table function