NamedItem resource type

Represents a defined name for a range of cells or value. Names can be primitive named objects (as seen in the type below), range object, reference to a range. This object can be used to obtain range object associated with names.

Methods

Method Return Type Description
Get NamedItem NamedItem Read properties and relationships of namedItem object.
Update NamedItem Update NamedItem object.
Range Range Returns the range object that is associated with the name. Throws an exception if the named item's type is not a range.
List NamedItem collection Get namedItem object collection.

Properties

Property Type Description
name string The name of the object. Read-only.
type string Indicates what type of reference is associated with the name. Possible values are: String, Integer, Double, Boolean, Range. Read-only.
value object Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
visible boolean Specifies whether the object is visible or not.

Relationships

None

JSON representation

Here is a JSON representation of the resource.

{
  "name": "string",
  "type": "string",
  "value": {"@odata.type": "microsoft.graph.range"},
  "visible": true
}