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)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |