Field element

Specifies the cell or cells in the spreadsheet that are being mapped.

Usage

      
<Field
	ID="xsd:string"
/>

    

Element Information

Element type FieldType
Namespace http://schemas.microsoft.com/office/excel/2003/xml
Schema name XML Spreadsheet 2003

Elements and Attributes

Parent Elements

Element Description
Entry Specifies a mapping between cells and elements or attributes. There is one Entry element for each mapped cell.

Child Elements

Element Description
Range Contains a relative address that specifies which column is to be used for each of the elements mapped from the XML document.
XPath Contains a relative path from the parent element to the child element that is to be mapped to the column specified in the Range element.
XSDType "Contains the data type of the element or attribute being mapped, using the data types from the W3C Schema specification."
Aggregate Indicates the kind of aggregation to be done in the totals row.
ss:Cell See external namespace.
x:DataValidation See external namespace.
x:AutoFilterColumn See external namespace.

Attributes

Attribute Type Required Description Possible Values
ID xsd:string optional Specifies the column heading value. See external namespace.

Definition

      
<xsd:element name="Field" type="FieldType" minOccurs="0" maxOccurs="unbounded" >
</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