Create a summary table to analyze data
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Source Sheet sourceSheetName | string | Required | — | — |
Row Field(s) rowFields | string | Required | — | — |
Column Field(s) columnFields | string | Optional | — | — |
Value Field valueField | string | Required | — | — |
Aggregation aggregation | enum | Optional | sum | —sumcountaveragemaxmin |
Pivot Sheet Name pivotSheetName | string | Optional | Pivot | — |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Auto Fill Range
Fill a source cell's formula or value across a range, adjusting relative references like dragging the Excel fill handle. Absolute references (with $) stay pinned.
Close Excel Workbook
Save and close the Excel file
Convert Excel to PDF
Export the workbook (or a single sheet) to PDF, preserving layout, charts, and conditional formatting.
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Delete WorkSheet Columns
Remove specific columns from a sheet