Connections Part

Content Type:

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

Root Namespace:

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

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/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:

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

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

example:

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

A Connections part shall be located within the package containing the source relationship (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 this Standard..