Get Range

Retrieve the properties and relationships of range object.

Prerequisites

The following scopes are required to execute this API:

HTTP request

GET /workbook/worksheets(<id|name>)/range(address='<address>')
GET /workbook/tables(<id|name>)/columns(<id|name>)/range

Optional query parameters

This method supports the OData Query Parameters to help customize the response.

Request headers

Name Description
Authorization Bearer

Request body

Do not supply a request body for this method.

Response

If successful, this method returns a 200 OK response code and Range object in the response body.

Example

Request

Here is an example of the request.

GET https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/names(<name>)/range
Response

Here is an example of the response. Note: The response object shown here may be truncated for brevity. All of the properties will be returned from an actual call.

HTTP/1.1 200 OK
Content-type: application/json
Content-length: 169

{
  "address": "address-value",
  "addressLocal": "addressLocal-value",
  "cellCount": 99,
  "columnCount": 99,
  "columnIndex": 99,
  "valueTypes": "valueTypes-value"
}