Table

Represents an Excel table.

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

Properties

Name	Type	Description
id	string	Unique identifier for the table.
name	string	The name of the table.
showHeaders	boolean	Whether the header row is visible.
showTotals	boolean	Whether the total row is visible.
style	string	Table style name.

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-schema.json",
  "title": "Table",
  "description": "Represents an Excel table.",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "Unique identifier for the table."
    },
    "name": {
      "type": "string",
      "description": "The name of the table."
    },
    "showHeaders": {
      "type": "boolean",
      "description": "Whether the header row is visible."
    },
    "showTotals": {
      "type": "boolean",
      "description": "Whether the total row is visible."
    },
    "style": {
      "type": "string",
      "description": "Table style name."
    }
  }
}