DocumentID: ECMA-376/Part4/3.14 Title: ECMA-376, Part4: 3.14 Supplementary Workbook Data 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
External links are used when linking the workbook to other workbooks or external data. The most frequent feature for linking a workbook to other workbooks is through the use of formulas. In this case the formula references a range or defined name in another workbook. Hyperlinks on cells and other spreadsheet objects are also considered an external link. OLE links are yet another technology used to link the workbook to another object. Finally, Dynamic Data Exchange, or DDE, servers can be used to access external data. DDE servers are accessed through formulas in the workbook.
External links are saved with the target source in a relationship file so that external resources are easily discoverable in lightweight relationship XML rather than deep in the application's XML.
For a workbook consumer.xlsx that makes use of data in another workbook called data.xlsx, the following XML would exist in consumer.xlsx to describe the external link:
[Example:
<Relationships xmlns="...">
<Relationship Id="rId1" Type=".../externalLinkPath" Target="data.xlsx"
TargetMode="External"/>
</Relationships>
end example]
And the following XML would exist to describe cached data retrieved from the external workbook:
[Example:
<externalLink xmlns="...">
<externalBook xmlns:r="..." r:id="rId1">
<sheetNames>
<sheetName val="Sheet1"/>
<sheetName val="Sheet2"/>
<sheetName val="Sheet3"/>
</sheetNames>
<sheetDataSet>
<sheetData sheetId="0"/>
<sheetData sheetId="1"/>
<sheetData sheetId="2">
<row r="11">
<cell r="B11">
<v>47</v>
</cell>
</row>
<row r="12">
<cell r="B12">
<v>19</v>
</cell>
</row>
<row r="13">
<cell r="B13">
<v>38</v>
</cell>
</row>
</sheetData>
</sheetDataSet>
</externalBook>
</externalLink>
end example]
The Supplementary Workbook Data section of SpreadsheetML is complimentary to the External Data Connnections (§3.13) section in maintaining all the information about external information that impacts the workbook.