Entry element

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

Usage

      
<Entry
	ID="xsd:string"
	ShowTotals="truefalseType"
	Type="xsd:string"
/>

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
Map Specifies the mapping between the elements and attributes in the schema and the cells in the spreadsheet.

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:element name="Entry" type="EntryType" 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