excel_create_pivot_table
Generate a pivot table from specified data range in an Excel file to summarize and analyze data with row, column, and value fields.
Instructions
Create a pivot table for data analysis
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the Excel file | |
| sourceSheetName | Yes | Source sheet name | |
| sourceRange | Yes | Source data range | |
| targetSheetName | Yes | Target sheet for pivot table | |
| targetCell | Yes | Target cell (e.g., A1) | |
| rows | Yes | Row fields | |
| columns | No | Column fields | |
| values | Yes | Value fields with aggregation | |
| createBackup | No |