Create Pivot Table
Creates a pivot table from a range in Microsoft Excel, with row, column and value fields, and saves the workbook. Needs Excel installed.
Behaviour
Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash
Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.desktop.createPivotTable
Properties#
Input#
Workbook Path#
WorkbookPath · String · Required · Default: Not specified in package metadata
The .xlsx, .xlsm, .xlsb or .xls file. Relative paths resolve against the project folder.
Source Sheet#
SourceSheet · String · Required · Default: Sheet1
The sheet holding the data.
Source Range#
SourceRange · String · Required · Default: Not specified in package metadata
The data, headers in the first row.
Table Name#
TableName · String · Required · Default: Not specified in package metadata
The pivot table's name.
Destination Sheet#
DestinationSheet · String · Required · Default: Not specified in package metadata
The sheet that gets the pivot table; created when missing.
Destination Cell#
DestinationCell · String · Optional · Default: A3
The pivot table's top-left cell.
Row Fields#
RowFields · IReadOnlyList<String> · Optional · Default: Not specified in package metadata
Source headers that become rows.
Column Fields#
ColumnFields · IReadOnlyList<String> · Optional · Default: Not specified in package metadata
Source headers that become columns.
Value Fields#
ValueFields · IReadOnlyList<String> · Optional · Default: Not specified in package metadata
Source headers that are summarized.
Function#
Function · String · Optional · Default: Sum
How value fields are summarized.
Allowed values: Sum, Count, Average, Max, Min.
Retry and risk#
This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.
Every activity also has the engine's common properties: Timeout and Continue On Error.
Related activities#
Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel Desktop. Keywords: excel, pivot, pivot table, summarize, aggregate, create, desktop.
Properties
Input
Retry and risk
Related activities