create_pivot_table
Builds a pivot table in an Excel worksheet to summarize data using selected rows, columns, and aggregation functions.
Instructions
Create pivot table in worksheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| values | Yes | ||
| columns | No | ||
| agg_func | No | sum | |
| filepath | Yes | ||
| data_range | Yes | ||
| sheet_name | Yes | ||
| replace_existing | No |