Describe sheet
describe_sheetInspect a worksheet's structure: used range, frozen panes, merged ranges, tables, charts, validation, conditional formats, and custom column widths.
Instructions
Describe a sheet's structure: used range, frozen panes, merged ranges, tables, charts, data validation, conditional formats and custom column widths.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| sheet | Yes | Worksheet name, e.g. 'Sheet1'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| tables | Yes | ||
| used_range | Yes | ||
| auto_filter | Yes | ||
| chart_count | Yes | ||
| freeze_panes | Yes | ||
| column_widths | Yes | ||
| merged_ranges | Yes | ||
| data_validations | Yes | ||
| conditional_formats | Yes |