DocumentID: ECMA-376/Part1/12.3.6
Title: ECMA-376, Part1: 12.3.6 Custom XML Mappings Part
Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006
Warning: Coverted to HTML format by a script known to have bugs

• Next: 12.3.7 Dialogsheet Part
• Up: 12.3 Part Summary
• Table of contents: Table of contents
• Previous: 12.3.5 Custom Property Part

12.3.6 Custom XML Mappings Part

An instance of this part type contains a schema for an XML file, and information on the behavior that is used when allowing this custom XML schema to be mapped into the spreadsheet.

A package shall contain no more than one Custom XML Mappings part, and that part shall be the target of an implicit relationship from the Workbook part (§12.3.23). The Worksheet part into which this data is imported shall also have a relationship file that targets one or more Table Definition (§12.3.21) parts and/or one or more Single Cell Table Defintions (§12.3.19) parts.

[Example: The following Workbook part-relationship item contains a relationship to the Custom XML Mappings part, which is stored in the ZIP item xmlMaps.xml:

<Relationships xmlns="...">
  <Relationship Id="rId9" 
    Type="http://.../xmlMaps" Target="xmlMaps.xml"/>
</Relationships>

end example]

The root element for a part of this content type shall be mapInfo.

[Example: xmlMaps.xml contains the following:

<mapInfo SelectionNamespaces="">
  <Schema ID="Schema1">
    <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <xsd:element nillable="true" name="names">
       <xsd:complexType>

           <xsd:sequence minOccurs="0">
             <xsd:element minOccurs="0" maxOccurs="unbounded" 
               nillable="true" name="name" form="unqualified">

               <xsd:complexType>
                 <xsd:sequence minOccurs="0">
                   <xsd:element minOccurs="0" nillable="true" 
                     type="xsd:string" name="firstname"
                     form="unqualified"/>
                   <xsd:element minOccurs="0" nillable="true"
                     type="xsd:string" name="initial"
                     form="unqualified"/>
                   <xsd:element minOccurs="0" nillable="true" 
                     type="xsd:string" name="lastName"
                     form="unqualified"/>
                </xsd:sequence>
              </xsd:complexType>

            </xsd:element>
          </xsd:sequence>

        </xsd:complexType>
      </xsd:element>
    </xsd:schema>
  </Schema>

  <Map ID="1" Name="names_Map" RootElement="names" SchemaID="Schema1"
    ShowImportExportValidationErrors="false" AutoFit="true"
    Append="false" 
    PreserveSortAFLayout="true" PreserveFormat="true">
    <DataBinding FileBinding="Test.xml" DataBindingLoadMode="1"/>
  </Map>
</mapInfo>

end example]

A Custom XML Mappings part shall be located within the package containing the source relationship (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Custom XML Mappings part shall not have implicit or explicit relationships to any other part defined by this Standard.