create-excel-table
Convert a worksheet range into a formal Excel table. Required before adding, updating, or deleting rows.
Instructions
Create a new table. The range source address determines the worksheet under which the table will be added. If the table can't be added (for example, because the address is invalid, or the table would overlap with another table), an error is generated.
💡 TIP: Convert a worksheet range into a formal Excel table. Body: { address: 'A1:H171', hasHeaders: true }. Required before using add-excel-table-rows / update-excel-table-row / delete-excel-table-row on a plain-cells sheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| body | Yes | ||
| driveId | Yes | Path parameter: driveId | |
| driveItemId | Yes | Path parameter: driveItemId | |
| workbookWorksheetId | Yes | Path parameter: workbookWorksheetId | |
| 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 |