NamedItem resource type
2 minutes to read
In this article
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.
NamedItem Adds a new name to the collection of the given scope.
NamedItem Adds a new name to the collection of the given scope using the user's locale for the formula.
NamedItem Read properties and relationships of namedItem object.
NamedItem Update NamedItem object.
Range Returns the range object that is associated with the name. Throws an exception if the named item's type is not a range.
NamedItem collection Get namedItem object collection.
The name of the object. Read-only.
Represents the comment associated with this name.
Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
Indicates what type of reference is associated with the name. Possible values are:
Represents the formula that the name is defined to refer to. E.g. =Sheet14!$B$2:$H$12, =4.75, etc. Read-only.
Specifies whether the object is visible or not.
worksheet Returns the worksheet on which the named item is scoped to. Available only if the item is scoped to the worksheet. Read-only.
Here is a JSON representation of the resource.