NamesType complexType

Defines the collection of named ranges within a workbook or worksheet.

Type Information

Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

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:complexType name="NamesType" >
  <xsd:sequence>
    <xsd:element name="NamedRange" minOccurs="0" maxOccurs="unbounded">
      <xsd:complexType>
        <xsd:attribute form="qualified" name="Name" type="xsd:string" use="required">
        </xsd:attribute>
        <xsd:attribute form="qualified" name="RefersTo" type="xsd:string" use="optional">
        </xsd:attribute>
        <xsd:attribute ref="Hidden" default="0" />
        <xsd:attribute ref="c:PasteRefersTo" use="optional" />
      </xsd:complexType>
    </xsd:element>
  </xsd:sequence>
</xsd:complexType>


    
©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