Describe a worksheet
describe_sheetPreview a sheet's headers, row count, and sample rows to plan targeted queries without pulling full data.
Instructions
Inspect a sheet without pulling its data: returns the column headers, the total row count, and up to 3 sample rows. Call this FIRST against an unfamiliar matrix so you can build a targeted filter for get_permission_matrix instead of pulling everything.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| link | No | SharePoint sharing link (…/:x:/s/Site/TOKEN?e=code) or a direct document URL. Omit if supplying driveId and itemId. | |
| sheet | No | Worksheet name. Defaults to the first sheet. | |
| itemId | No | Item ID from resolve_link. Use with driveId. | |
| driveId | No | Drive ID from resolve_link. Use with itemId. | |
| headerRow | No | 1-indexed header row. Default 1. |