EntryType complexType

Defines the mappings between cells in the spreadsheet and the elements or attributes in the schema specified in the parent Map element.

Type Information

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

Elements and Attributes

Child Elements

Element Description
Range Contains the address of the cell mapped by this entry.
HeaderRange Contains an absolute reference (in R1C1 reference style) to the first cell in the row of headers for a table mapping.
XPath Contains an XPath statement that points to the elements or attributes being mapped.
Field Specifies the cell or cells in the spreadsheet that are being mapped.
ActiveRows Contains XDT rows that are active.
NoInserts This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
ReadOnly This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
InstanceShape This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
x:FilterOn See external namespace.

Attributes

Attribute Type Required Description Possible Values
ID xsd:string required Specifies a unique identifier for the Entry element. See external namespace.
ShowTotals truefalseType optional Specifies whether the total row will be displayed when mapped to a list or table.
  • true
  • false
Type Anonymous optional Indicates whether the mapping will be to a single cell or to a table or list.
  • single
  • table

Definition

      
<xsd:complexType name="EntryType" >
  <xsd:sequence>
    <xsd:element name="Range" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="HeaderRange" minOccurs="0">
    </xsd:element>
    <xsd:element ref="x:FilterOn" minOccurs="0" />
    <xsd:element name="XPath" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="Field" type="FieldType" minOccurs="0" maxOccurs="unbounded">
    </xsd:element>
    <xsd:element name="ActiveRows" type="ActiveRowsType" minOccurs="0">
    </xsd:element>
    <xsd:element name="NoInserts" minOccurs="0">
    </xsd:element>
    <xsd:element name="ReadOnly" minOccurs="0">
    </xsd:element>
    <xsd:element name="InstanceShape" type="xsd:string" minOccurs="0">
    </xsd:element>
  </xsd:sequence>
  <xsd:attribute name="ID" type="xsd:string" use="required">
  </xsd:attribute>
  <xsd:attribute name="ShowTotals" type="truefalseType">
  </xsd:attribute>
  <xsd:attribute name="Type" use="optional" default="table">
    <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>


    
©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