Map element

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

Usage

      
<Map
	ID="xsd:string"
	SchemaID="xsd:string"
	RootElement="xsd:string"
/>

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
MapInfo Specifies the mapping of XML document elements and attributes to spreadsheet cells.

Child Elements

Element Description
ShowImportExportValidationErrors Specifies whether a spreadsheet will be saved if the resulting XML document will not be valid based on the associated schema.
Append "Specifies that data is appended to a map on refresh, rather than overwriting current data."
Entry Specifies a mapping between cells and elements or attributes. There is one Entry element for each mapped cell.
Mapdata Specifies whether UDC bound data is preserved.
x:DoNotPersist See external namespace.
x:NoAutoFit See external namespace.
x:NoPreserveFormatting See external namespace.

Attributes

Attribute Type Required Description Possible Values
ID xsd:string optional Specifies the unique identifier for a map. See external namespace.
SchemaID xsd:string optional Specifies the value of the ID attribute for the XML Spreadsheet 2003 schema element that is used by a map. See external namespace.
RootElement xsd:string optional Contains the unqualified name of the root element of the schema. See external namespace.

Definition

      
<xsd:element name="Map" type="MapType" 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