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
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"filePath": "<filePath>",
"sourceSheetName": "<sourceSheetName>",
"sourceRange": "<sourceRange>",
"targetSheetName": "<targetSheetName>",
"targetCell": "<targetCell>",
"rows": "<rows>",
"values": "<values>"
},
"name": "excel_create_pivot_table"
}
}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 |