List Power Query
xlide_list_queriesList Power Query queries in an Excel workbook, including names, groups, load targets, and applied steps. Use this to understand what a workbook does, even if it has no macros.
Instructions
Lists the Power Query queries in an Excel workbook: name, group, description, where each loads, and its applied step names. Queries live outside the VBA project, so a plain .xlsx has them too. Call this when asked what a workbook does; a workbook with no macros can still be doing most of its work here.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Absolute path to the Excel workbook. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||