Add a live PivotTable with a field list and slicers. Needs Excel installed on Windows. Put this step last: a later Excel step rewrites the file and drops the pivot
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Data Sheet sourceSheetName | string | Optional | — | The sheet holding the data. Leave empty for the first sheet. |
Data Range sourceRange | string | Optional | — | For example A1:F500. Leave empty to use everything on the sheet. |
Filters filterFields | array | Optional | — | Optional column headings, as drop-downs above the pivot |
Columns columnFields | array | Optional | — | Optional column headings, across the top of the pivot |
Rows rowFields | array | Required | — | One or more column headings, down the left of the pivot |
Values valueField | string | Required | — | The column heading holding the numbers to total |
Summarise Values By aggregation | enum | Optional | sum | —sumcountaveragemaxmin |
Put Pivot On pivotSheetName | string | Optional | Pivot | Created if it does not exist yet |
Top-Left Cell targetCell | string | Optional | A3 | — |
Pivot Name pivotName | string | Optional | ExekraPivot | — |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create Summary Table
Group and total data into a summary table. Works without Excel; for a live pivot use Insert Pivot Table
Export Chart as Image
Write a chart out as a picture, for an email or a document where the reader will not have the workbook. Needs Windows with Microsoft Excel installed
Insert Chart
Add a real Excel chart to a sheet. Needs Windows with Microsoft Excel installed. Put this step last: a later Excel step rewrites the file and drops the chart
Update Chart
Re-point an existing chart at different data, or retitle it, keeping the position, colours and axis scale a reader set by hand. Needs Windows with Microsoft Excel installed
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row