DocumentID: ECMA-376/Part4/3.12 Title: ECMA-376, Part4: 3.12 QueryTable 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
Query tables are 2 dimensional tables of data bound to an external query of some kind. A query table could for example show specific data from a text file, from a web query, or from a database query.
[Example:
Data connectivity can use a number of different technologies. The following spreadsheetML fragment is one an example of a query table connected to a database:
<queryTable xmlns="..." name="Northwind Orders" rowNumbers="1"
growShrinkType="overwriteClear" connectionId="1" autoFormatId="16"
applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="0"
applyPatternFormats="0" applyAlignmentFormats="0" applyWidthHeightFormats="0">
<queryTableRefresh nextId="15">
<queryTableFields count="12">
<queryTableField id="1" name="OrderID" tableColumnId="1"/>
<queryTableField id="2" name="CustomerID" tableColumnId="2"/>
<queryTableField id="3" name="EmployeeID" tableColumnId="3"/>
<queryTableField id="4" name="OrderDate" tableColumnId="4"/>
<queryTableField id="5" name="RequiredDate" tableColumnId="5"/>
<queryTableField id="6" name="ShippedDate" tableColumnId="6"/>
<queryTableField id="7" name="ShipName" tableColumnId="7"/>
<queryTableField id="8" name="ShipAddress" tableColumnId="8"/>
<queryTableField id="9" name="ShipCity" tableColumnId="9"/>
<queryTableField id="10" name="ShipRegion" tableColumnId="10"/>
<queryTableField id="11" name="ShipPostalCode" tableColumnId="11"/>
<queryTableField id="12" name="ShipCountry" tableColumnId="12"/>
</queryTableFields>
</queryTableRefresh>
</queryTable>
end example]
And here's an example of the spreadsheetML fragment defining a query table connected to a text import:
[Example:
<queryTable xmlns="..." name="data in text" connectionId="1" autoFormatId="16"
applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="1"
applyPatternFormats="1" applyAlignmentFormats="0"
applyWidthHeightFormats="0"/>
end example]
Elsewhere in the spreadsheetML file, a connection element is defined with the name "Northwind Orders" that describes how to connect to the appropriate database to refresh data for the query table.