External Workbook References Part

Content Type:

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

Root Namespace:

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

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLink

An instance of this part specifies information about data referenced in other SpreadsheetML packages.

example:

A package is permitted to contain one or more External Workbook References parts, and those parts shall be the target of an explicit relationship in the Workbook part (§12.3.23).

example:

<workbook xmlns:r="…"/>
  …
  <sheets>
    <sheet name="Sheet1" tabId="1" r:id="rId1"/>
    <sheet name="Sheet2" tabId="2" r:id="rId2"/>
    <sheet name="Sheet3" tabId="3" r:id="rId3"/>
  </sheets>
  …
  <externalReferences>
    <externalReference r:id="rId4"/>
  </externalReferences>
  …
</workbook>

That part's relationship item contains the following:

<Relationships xmlns="…">
  <Relationship Id="rId4" 
    Type="http://…/externalLink" 
    Target="externalReferences/externalReference1.xml"/>
</Relationships>

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

example:

<externalLink xmlns:r="…" … r:id="rId1">
  <externalBook>
    <sheetNames>
      <sheetName val="Sheet1"/>
      <sheetName val="Sheet2"/>
      <sheetName val="Sheet3"/>
    </sheetNames>
    <sheetDataSet>
      <sheetData sheetId="0">
        <row r="7">
          <cell r="C8">
            <v>0</v>
          </cell>
        </row>
      </sheetData>
      <sheetData sheetId="1"/>
      <sheetData sheetId="2"/>
    </sheetDataSet>
  </externalBook>
</externalLink>

This part's relationship item contains the following:

<Relationships …>
  <Relationship Id="rId1" 
    Type="…/externalReference" 
    Target="wb2.xlsx" TargetMode="External"/>
</Relationships>

where wb2.xlsx is the workbook in which one or more cells' values are used in calculating the values of a cell in workbook wb1. ]

An External Workbook References part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

An External Workbook References part shall specify an explicit relationship to one or more this StandardExternal Workbooks (§12.4).

An External Workbook References part shall not have any implicit or explicit relationships to other parts defined by this Standard.