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