12.3.4 Connections Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.connections+xml

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/connections

An instance of this part type describes all of the connections currently established for a workbook.

A package shall contain no more than one Connections part, and that part shall be the target of an implicit relationship from the Workbook part (12.3.23).

[Example: The following Workbook part-relationship item contains a relationship to the Connections part, which is stored in the ZIP item connections.xml:

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

end example]

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

[Example: A workbook has three connections, two from one worksheet, and one from another. connections.xml defines these three connections:

<connections …>
  <connection id="1" odcFile="…" keepAlive="1" name="…" type="5"
    refreshedVersion="2" background="1" saveData="1">
    <dbPr connection="Provider=MSDASQL.1;Persist Security Info=True;Data
Source=dBASE Files;Extended Properties=&quot;DSN=dBASE Files;DBQ=E:\MY
DOCUMENTS;DefaultDir=E:\MY
DOCUMENTS;DriverId=533;MaxBufferSize=2048;PageTimeout=5;&quot;;Initial
Catalog=E:\MY DOCUMENTS" command="`E:\MY DOCUMENTS`\`ADDRESS`" commandType="3"/>
  </connection>
  <connection id="2" …>
    <dbPr … />
  </connection>
  <connection id="3" …>
    <dbPr … />
  </connection>
</connections>

end example]

A Connections part shall be located within the package containing the relationships part (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Connections part shall not have implicit or explicit relationships to any part defined by ISO/IEC 29500..