<definedName>
(Defined Name)
This element contains information about a named range in an external workbook.
Parent Elements |
---|
|
Attributes |
Description |
---|---|
|
The defined name. This attribute is required. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Name range definition string. example:
<definedNames> <definedName name="namedrange" refersTo="='Sheet1'!$D$5:$D$10"/> </definedNames> The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
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>