Names element (WorksheetType complexType)
Defines a collection of named ranges within a workbook or worksheet.
Usage
<Names
Name="xsd:string"
RefersTo="xsd:string"
Hidden="See attribute definition. c:PasteRefersTo="[external type]"
/>
Element Information
Element type
|
NamesType |
Namespace
|
urn:schemas-microsoft-com:office:spreadsheet |
Schema name
|
XML Spreadsheet 2002 |
Elements and Attributes
Parent Elements
Element |
Description |
Worksheet |
Defines a worksheet within the current workbook. At least one instance of this element is required for a valid XML spreadsheet. |
Child Elements
Element |
Description |
NamedRange |
Defines a single named range within this workbook. |
Attributes
Attribute |
Type |
Required |
Description |
Possible Values |
Name |
xsd:string |
required |
Specifies the name of a named range. |
See external namespace. |
RefersTo |
xsd:string |
optional |
Specifies the range to which the name applies. |
See external namespace. |
Hidden |
None |
optional |
Specifies whether an element is visible. The Hidden attribute can be applied to the NamedRange, Column, and Row elements. |
n/a |
c:PasteRefersTo |
external ref |
optional |
See external namespace. |
See external namespace. |
Definition
<xsd:element name="Names" type="NamesType" minOccurs="0" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved.
Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp