[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
definedName (Defined Name)
This element contains information about a named range in an external workbook.
|
Parent Elements |
|
definedNames (§3.14.6) |
|
Attributes |
Description |
|
name (Defined Name) |
The defined name. This attribute is required.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
refersTo (Refers To) |
Name range definition string.
[Example:
<definedNames>
…end example]
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
sheetId (Sheet Id) |
The index of the worksheet that the named range applies to for named ranges that are scoped to a particular worksheet rather than the full workbook. This attribute is optional.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_ExternalDefinedName">
<attribute name="name" type="ST_Xstring" use="required"/>
<attribute name="refersTo" type="ST_Xstring" use="optional"/>
<attribute name="sheetId" type="xsd:unsignedInt" use="optional"/>
</complexType>