list_pivot_tables
List all pivot tables in an Excel workbook, showing their names, sheet locations, output ranges, and source data ranges to quickly audit or navigate pivot structures.
Instructions
Return every pivot table in the workbook.
Each entry contains:
name: pivot table name
sheet: sheet the pivot table is rendered on
ref: cell range of the pivot table output
source_sheet: data source sheet (if determinable, else null)
source_ref: data source range (if determinable, else null)
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": {
"file_path": "<file_path>"
},
"name": "list_pivot_tables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |