format-excel-range
Apply alignment, wrap text, column width, and row height formatting to an Excel range. Configure font, fill, and borders via separate endpoints.
Instructions
Update the navigation property format in drives
💡 TIP: Apply rangeFormat properties to a specific range. Required path param 'address' (e.g. 'A1:E5' or 'Sheet1!A1:E5'). Body: { horizontalAlignment, verticalAlignment, wrapText, columnWidth, rowHeight }. Note: font, fill, and borders are sub-resources on rangeFormat — set them via /format/font, /format/fill, and /format/borders/{sideIndex} respectively, not on this endpoint.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| body | Yes | ||
| driveId | Yes | Path parameter: driveId | |
| driveItemId | Yes | Path parameter: driveItemId | |
| workbookWorksheetId | Yes | Path parameter: workbookWorksheetId | |
| address | Yes | Path parameter: address | |
| 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 |