NamedItem

Represents a defined name for a cell range or value.

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

Properties

Name	Type	Description
name	string	The name of the named item.
type	string	The type of the named item.
value	string	The formula or range reference.
visible	boolean	Whether the named item is visible.

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-named-item-schema.json",
  "title": "NamedItem",
  "description": "Represents a defined name for a cell range or value.",
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "description": "The name of the named item."
    },
    "type": {
      "type": "string",
      "description": "The type of the named item."
    },
    "value": {
      "type": "string",
      "description": "The formula or range reference."
    },
    "visible": {
      "type": "boolean",
      "description": "Whether the named item is visible."
    }
  }
}