Definition Type: ComplexType
Name: EntryType
Namespace: http://schemas.microsoft.com/office/excel/2003/xml
Containing Schema: excel2003xml.xsd
Abstract
Documentation:
Defines the mappings between cells in the spreadsheet and the elements or attributes in the schema specified in the parent Map element.
Collapse XSD Schema Diagram:
Drilldown into InstanceShape in schema excel2003xml_xsd Drilldown into ReadOnly in schema excel2003xml_xsd Drilldown into NoInserts in schema excel2003xml_xsd Drilldown into ActiveRows in schema excel2003xml_xsd Drilldown into Field in schema excel2003xml_xsd Drilldown into XPath in schema excel2003xml_xsd Drilldown into FilterOn in schema excel_xsd Drilldown into HeaderRange in schema excel2003xml_xsd Drilldown into Range in schema excel2003xml_xsd Drilldown into Type in schema excel2003xml_xsd Drilldown into ShowTotals in schema excel2003xml_xsd Drilldown into ID in schema excel2003xml_xsdXSD Diagram of EntryType in schema excel2003xml_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:complexType name="EntryType">
    <xsd:annotation>
        <xsd:documentation>Defines the mappings between cells in the spreadsheet and the elements or attributes in the schema specified in the parent Map element.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Range" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the address of the cell mapped by this entry.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HeaderRange" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an absolute reference (in R1C1 reference style) to the first cell in the row of headers for a table mapping.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element ref="x:FilterOn" minOccurs="0" />
        <xsd:element name="XPath" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an XPath statement that points to the elements or attributes being mapped.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Field" type="FieldType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the cell or cells in the spreadsheet that are being mapped.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ActiveRows" type="ActiveRowsType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains XDT rows that are active.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoInserts" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ReadOnly" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="InstanceShape" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="ID" type="xsd:string" use="required">
        <xsd:annotation>
            <xsd:documentation>Specifies a unique identifier for the Entry element.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="ShowTotals" type="truefalseType">
        <xsd:annotation>
            <xsd:documentation>Specifies whether the total row will be displayed when mapped to a list or table.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="Type" use="optional" default="table">
        <xsd:annotation>
            <xsd:documentation>Indicates whether the mapping will be to a single cell or to a table or list.</xsd:documentation>
        </xsd:annotation>
        <xsd:simpleType>
            <xsd:restriction base="xsd:string">
                <xsd:enumeration value="single" />
                <xsd:enumeration value="table" />
            </xsd:restriction>
            <!--data types-->
        </xsd:simpleType>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Range x2:Range 0 (1)
HeaderRange x2:HeaderRange 0 (1)
FilterOn x:FilterOn 0 (1)
XPath x2:XPath 0 (1)
Field x2:Field 0 unbounded
ActiveRows x2:ActiveRows 0 (1)
NoInserts x2:NoInserts 0 (1)
ReadOnly x2:ReadOnly 0 (1)
InstanceShape x2:InstanceShape 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
ID x2:ID Required
ShowTotals x2:ShowTotals (Optional)
Type x2:Type table Optional
Collapse Derivation Tree:
Collapse References:
x2:Entry