Custom XML Mappings Part

Content Type:

application/xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/xmlMaps

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:

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

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

example:

<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>

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.