Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: FieldType
Namespace: http://schemas.microsoft.com/office/excel/2003/xml
Containing Schema: excel2003xml.xsd
Abstract
Documentation:
Specifies which cells in the spreadsheet are to be mapped to the data pointed to by the XPath element.
Collapse XSD Schema Diagram:
Drilldown into AutoFilterColumn in schema excel_xsd Drilldown into Aggregate in schema excel2003xml_xsd Drilldown into DataValidation in schema excel_xsd Drilldown into Cell in schema excelss_xsd Drilldown into XSDType in schema excel2003xml_xsd Drilldown into XPath in schema excel2003xml_xsd Drilldown into Range in schema excel2003xml_xsd Drilldown into ID in schema excel2003xml_xsdXSD Diagram of FieldType in schema excel2003xml_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="FieldType">
    <xsd:annotation>
        <xsd:documentation>Specifies which cells in the spreadsheet are to be mapped to the data pointed to by the XPath element.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Range" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a relative address that specifies which column is to be used for each of the elements mapped from the XML document.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="XPath" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="XSDType" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>"Contains the data type of the element or attribute being mapped, using the data types from the W3C Schema specification."</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element ref="ss:Cell" minOccurs="0" />
        <xsd:element ref="x:DataValidation" minOccurs="0" />
        <xsd:element name="Aggregate" minOccurs="0" default="None">
            <xsd:annotation>
                <xsd:documentation>Indicates the kind of aggregation to be done in the totals row.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="None" />
                    <xsd:enumeration value="Sum" />
                    <xsd:enumeration value="Count" />
                    <xsd:enumeration value="CountNums" />
                    <xsd:enumeration value="Var" />
                    <xsd:enumeration value="Average" />
                    <xsd:enumeration value="stdDev" />
                    <xsd:enumeration value="Max" />
                    <xsd:enumeration value="Min" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element ref="x:AutoFilterColumn" minOccurs="0" />
    </xsd:sequence>
    <xsd:attribute name="ID" type="xsd:string">
        <xsd:annotation>
            <xsd:documentation>Specifies the column heading value.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Range x2:Range 0 (1)
XPath x2:XPath 0 (1)
XSDType x2:XSDType 0 (1)
Cell ss:Cell 0 (1)
DataValidation x:DataValidation 0 (1)
Aggregate x2:Aggregate 0 (1)
AutoFilterColumn x:AutoFilterColumn 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
ID x2:ID (Optional)
Collapse Derivation Tree:
Collapse References:
x2:Field
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0