microsoft.graph.workbookRange

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookRange",
  "title": "microsoft.graph.workbookRange",
  "allOf": [
    {
      "$ref": "#/components/schemas/microsoft.graph.entity"
    },
    {
      "title": "workbookRange",
      "required": [
        "@odata.type"
      ],
      "type": "object",
      "properties": {
        "address": {
          "type": "string",
          "description": "Represents the range reference in A1-style. Address value contains the Sheet reference (for example, Sheet1!A1:B4). Read-only.",
          "nullable": true
        },
        "addressLocal": {
          "type": "string",
          "description": "Represents range reference for the specified range in the language of the user. Read-only.",
          "nullable": true
        },
        "cellCount": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "Number of cells in the range. Read-only.",
          "format": "int32"
        },
        "columnCount": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "Represents the total number of columns in the range. Read-only.",
          "format": "int32"
        },
        "columnHidden": {
          "type": "boolean",
          "description": "Indicates whether all columns of the current range are hidden.",
          "nullable": true
        },
        "columnIndex": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "Represents the column number of the first cell in the range. Zero-indexed. Read-only.",
          "format": "int32"
        },
        "formulas": {
          "description": "Represents the formula in A1-style notation."
        },
        "formulasLocal": {
          "description": "Represents the formula in A1-style notation, in the user's language and number-formatting locale.  For example, the English '=SUM(A1, 1.5)' formula would become '=SUMME(A1; 1,5)' in German."
        },
        "formulasR1C1": {
          "description": "Represents the formula in R1C1-style notation."
        },
        "hidden": {
          "type": "boolean",
          "description": "Represents if all cells of the current range are hidden. Read-only.",
          "nullable": true
        },
        "numberFormat": {
          "description": "Represents Excel's number format code for the given cell."
        },
        "rowCount": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "Returns the total number of rows in the range. Read-only.",
          "format": "int32"
        },
        "rowHidden": {
          "type": "boolean",
          "description": "Indicates whether all rows of the current range are hidden.",
          "nullable": true
        },
        "rowIndex": {
          "maximum": 2147483647,
          "minimum": -2147483648,
          "type": "number",
          "description": "Returns the row number of the first cell in the range. Zero-indexed. Read-only.",
          "format": "int32"
        },
        "text": {
          "description": "Text values of the specified range. The Text value doesn't depend on the cell width. The # sign substitution that happens in Excel UI doesn't affect the text value returned by the API. Read-only."
        },
        "values": {
          "description": "Represents the raw values of the specified range. The data returned can be of type string, number, or a Boolean. Cell that contains an error returns the error string."
        },
        "valueTypes": {
          "description": "Represents the type of data of each cell. The possible values are: Unknown, Empty, String, Integer, Double, Boolean, Error. Read-only."
        },
        "format": {
          "anyOf": [
            {
              "$ref": "#/components/schemas/microsoft.graph.workbookRangeFormat"
            },
            {
              "type": "object",
              "nullable": true
            }
          ],
          "description": "Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. Read-only.",
          "x-ms-navigationProperty": true
        },
        "sort": {
          "anyOf": [
            {
              "$ref": "#/components/schemas/microsoft.graph.workbookRangeSort"
            },
            {
              "type": "object",
              "nullable": true
            }
          ],
          "description": "The worksheet containing the current range. Read-only.",
          "x-ms-navigationProperty": true
        },
        "worksheet": {
          "anyOf": [
            {
              "$ref": "#/components/schemas/microsoft.graph.workbookWorksheet"
            },
            {
              "type": "object",
              "nullable": true
            }
          ],
          "description": "The worksheet containing the current range. Read-only.",
          "x-ms-navigationProperty": true
        },
        "@odata.type": {
          "type": "string"
        }
      }
    }
  ],
  "x-ms-discriminator-value": "#microsoft.graph.workbookRange"
}