12.3.14 Query Table Part

Content Type:

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

Root Namespace:

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

Source Relationship:

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

An instance of this part type contains information that describes how the source table is connected to an external data source, and defines the properties that is used when this table is refreshed from that source.

A package is permitted to contain one Query Table part per table, and each of those parts shall be the target of an implicit relationship from the corresponding Table Definitions (12.3.21) part.

[Example: The following Table part-relationship item contains a relationship to the Query Table part corresponding to the connections details for that table. These parts are stored in the ZIP items ../queryTables/queryTablen.xml:

<Relationships xmlns="…">
  <Relationship Id="rId1"
    Type="http://…/queryTable"
    Target="../queryTables/queryTable1.xml"/>
</Relationships>

end example]

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

[Example: queryTable2.xml deals with a connection to a database file having the seven fields shown:

<queryTable … name="+Connect to New Data Source_1"
  growShrinkType="insertDelete" connectionId="2" autoFormatId="16"
  applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="1"
  applyPatternFormats="1" applyAlignmentFormats="0"
  applyWidthHeightFormats="0">
  <queryTableRefresh nextId="8">
    <queryTableFields count="7">
      <queryTableField id="1" name="ACCOUNT"/>
      <queryTableField id="2" name="CHECKNUM"/>
      <queryTableField id="3" name="DATE"/>
      <queryTableField id="4" name="AMOUNT"/>
      <queryTableField id="5" name="PAYEE"/>
      <queryTableField id="6" name="CHARGECODE"/>
      <queryTableField id="7" name="DESCRIPT"/>
    </queryTableFields>
  </queryTableRefresh>
</queryTable>

end example]

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

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