Group and total data into a summary table. Works without Excel; for a live pivot use Insert Pivot Table
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Source Sheet sourceSheetName | string | Required | — | — |
Group By rowFields | array | Required | — | One or more column headings to group the rows by |
Split Across Columns columnFields | array | Optional | — | Optional column headings to spread across the top |
Value Field valueField | string | Required | — | — |
Aggregation aggregation | enum | Optional | sum | —sumcountaveragemaxmin |
Pivot Sheet Name pivotSheetName | string | Optional | Pivot | — |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
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
Insert Pivot Table
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
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