format-excel-range
Update Excel range formatting: set alignment, text wrapping, column width, and row height for a specified range address.
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 |