TableColumn

Represents a column in an Excel table.

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

Properties

Name	Type	Description
id	string	Unique identifier for the column.
index	integer	Zero-based index of the column.
name	string	The name of the column.
values	array	Raw values of the column.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/microsoft-excel/refs/heads/main/json-schema/excel-graph-api-table-column-schema.json",
  "title": "TableColumn",
  "description": "Represents a column in an Excel table.",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "Unique identifier for the column."
    },
    "index": {
      "type": "integer",
      "description": "Zero-based index of the column."
    },
    "name": {
      "type": "string",
      "description": "The name of the column."
    },
    "values": {
      "type": "array",
      "description": "Raw values of the column.",
      "items": {
        "type": "array",
        "items": {}
      }
    }
  }
}