create_pivot_table
Create a pivot table in an Excel worksheet to summarize and analyze data. Configure rows, columns, values, and aggregation function for a structured view.
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 |