Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: Element
Name: queryTable
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_QueryTable
Containing Schema: sml-queryTable.xsd
Abstract
Documentation:
Query Table
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-querytable_xsd Drilldown into queryTableRefresh in schema sml-querytable_xsd Drilldown into applyWidthHeightFormats in schema sml-styles_xsd Drilldown into applyAlignmentFormats in schema sml-styles_xsd Drilldown into applyPatternFormats in schema sml-styles_xsd Drilldown into applyFontFormats in schema sml-styles_xsd Drilldown into applyBorderFormats in schema sml-styles_xsd Drilldown into applyNumberFormats in schema sml-styles_xsd Drilldown into autoFormatId in schema sml-styles_xsd Drilldown into AG_AutoFormat in schema sml-styles_xsd Drilldown into connectionId in schema sml-querytable_xsd Drilldown into intermediate in schema sml-querytable_xsd Drilldown into adjustColumnWidth in schema sml-querytable_xsd Drilldown into preserveFormatting in schema sml-querytable_xsd Drilldown into disableEdit in schema sml-querytable_xsd Drilldown into removeDataOnSave in schema sml-querytable_xsd Drilldown into fillFormulas in schema sml-querytable_xsd Drilldown into growShrinkType in schema sml-querytable_xsd Drilldown into refreshOnLoad in schema sml-querytable_xsd Drilldown into firstBackgroundRefresh in schema sml-querytable_xsd Drilldown into backgroundRefresh in schema sml-querytable_xsd Drilldown into disableRefresh in schema sml-querytable_xsd Drilldown into rowNumbers in schema sml-querytable_xsd Drilldown into headers in schema sml-querytable_xsd Drilldown into name in schema sml-querytable_xsd Drilldown into CT_QueryTable in schema sml-querytable_xsdXSD Diagram of queryTable in schema sml-querytable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:element name="queryTable" type="CT_QueryTable">
    <xsd:annotation>
        <xsd:documentation>Query Table</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
queryTableRefresh nsM:queryTableRefresh 0 1
extLst nsM:extLst 0 1
Collapse Child Attributes:
Name Type Default Value Use
name nsM:name Required
headers nsM:headers true Optional
rowNumbers nsM:rowNumbers false Optional
disableRefresh nsM:disableRefresh false Optional
backgroundRefresh nsM:backgroundRefresh true Optional
firstBackgroundRefresh nsM:firstBackgroundRefresh false Optional
refreshOnLoad nsM:refreshOnLoad false Optional
growShrinkType nsM:growShrinkType insertDelete Optional
fillFormulas nsM:fillFormulas false Optional
removeDataOnSave nsM:removeDataOnSave false Optional
disableEdit nsM:disableEdit false Optional
preserveFormatting nsM:preserveFormatting true Optional
adjustColumnWidth nsM:adjustColumnWidth true Optional
intermediate nsM:intermediate false Optional
connectionId nsM:connectionId Required
autoFormatId nsM:autoFormatId (Optional)
applyNumberFormats nsM:applyNumberFormats (Optional)
applyBorderFormats nsM:applyBorderFormats (Optional)
applyFontFormats nsM:applyFontFormats (Optional)
applyPatternFormats nsM:applyPatternFormats (Optional)
applyAlignmentFormats nsM:applyAlignmentFormats (Optional)
applyWidthHeightFormats nsM:applyWidthHeightFormats (Optional)
Collapse Derivation Tree:
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0