DocumentID: ECMA-376/Part1/12.3.4 Title: ECMA-376, Part1: 12.3.4 Connections 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
|
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: 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="DSN=dBASE Files;DBQ=E:\MY DOCUMENTS;DefaultDir=E:\MY DOCUMENTS;DriverId=533;MaxBufferSize=2048;PageTimeout=5;";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 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..