12.3.6 Custom XML Mappings Part
Content Type:
application/xml
Root Namespace:
http://purl.oclc.org/ooxml/spreadsheetml/main
Source Relationship:
http://purl.oclc.org/ooxml/officeDocument/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: 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 relationships part (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 ISO/IEC 29500.