microsoft.graph.workbookTable

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookTable",
  "title": "microsoft.graph.workbookTable",
  "allOf": [
    {
      "$ref": "#/components/schemas/microsoft.graph.entity"
    },
    {
      "title": "workbookTable",
      "required": [
        "@odata.type"
      ],
      "type": "object",
      "properties": {
        "highlightFirstColumn": {
          "type": "boolean",
          "description": "Indicates whether the first column contains special formatting."
        },
        "highlightLastColumn": {
          "type": "boolean",
          "description": "Indicates whether the last column contains special formatting."
        },
        "legacyId": {
          "type": "string",
          "description": "A legacy identifier used in older Excel clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and shouldn't be parsed to any other type. Read-only.",
          "nullable": true
        },
        "name": {
          "type": "string",
          "description": "The name of the table.",
          "nullable": true
        },
        "showBandedColumns": {
          "type": "boolean",
          "description": "Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier."
        },
        "showBandedRows": {
          "type": "boolean",
          "description": "Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier."
        },
        "showFilterButton": {
          "type": "boolean",
          "description": "Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row."
        },
        "showHeaders": {
          "type": "boolean",
          "description": "Indicates whether the header row is visible or not. This value can be set to show or remove the header row."
        },
        "showTotals": {
          "type": "boolean",
          "description": "Indicates whether the total row is visible or not. This value can be set to show or remove the total row."
        },
        "style": {
          "type": "string",
          "description": "A constant value that represents the Table style. The possible values are: TableStyleLight1 through TableStyleLight21, TableStyleMedium1 through TableStyleMedium28, TableStyleStyleDark1 through TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.",
          "nullable": true
        },
        "columns": {
          "type": "array",
          "items": {
            "$ref": "#/components/schemas/microsoft.graph.workbookTableColumn"
          },
          "description": "The list of all the columns in the table. Read-only.",
          "x-ms-navigationProperty": true
        },
        "rows": {
          "type": "array",
          "items": {
            "$ref": "#/components/schemas/microsoft.graph.workbookTableRow"
          },
          "description": "The list of all the rows in the table. Read-only.",
          "x-ms-navigationProperty": true
        },
        "sort": {
          "anyOf": [
            {
              "$ref": "#/components/schemas/microsoft.graph.workbookTableSort"
            },
            {
              "type": "object",
              "nullable": true
            }
          ],
          "description": "The sorting for the table. Read-only.",
          "x-ms-navigationProperty": true
        },
        "worksheet": {
          "anyOf": [
            {
              "$ref": "#/components/schemas/microsoft.graph.workbookWorksheet"
            },
            {
              "type": "object",
              "nullable": true
            }
          ],
          "description": "The worksheet containing the current table. Read-only.",
          "x-ms-navigationProperty": true
        },
        "@odata.type": {
          "type": "string"
        }
      }
    }
  ],
  "x-ms-discriminator-value": "#microsoft.graph.workbookTable"
}