get-excel-table
Read-only
Retrieve a specific table from an Excel workbook by its name or ID, including columns, headers, totals, and style.
Instructions
Represents a collection of tables associated with the workbook. Read-only.
đź’ˇ TIP: Gets a specific table by name or ID. Returns table properties including columns, showHeaders, showTotals, and style.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| select | No | Comma-separated fields to return, e.g. id,subject,from,receivedDateTime | |
| expand | No | Expand related entities | |
| driveId | Yes | Path parameter: driveId | |
| driveItemId | Yes | Path parameter: driveItemId | |
| workbookTableId | Yes | Path parameter: workbookTableId | |
| fetchAllPages | No | Follow @odata.nextLink and merge up to 100 pages into one response. Can return enormous payloads—only when the user explicitly needs a full export. Prefer a small $top first, then paginate or narrow with $filter/$search. | |
| includeHeaders | No | Include response headers (including ETag) in the response metadata | |
| excludeResponse | No | Exclude the full response body and only return success or failure indication |