Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_QueryTable
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-queryTable.xsd
Abstract
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_xsdXSD Diagram of CT_QueryTable in schema sml-querytable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_QueryTable">
    <xsd:sequence>
        <xsd:element name="queryTableRefresh" type="CT_QueryTableRefresh" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>QueryTable Refresh Information</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="name" type="ST_Xstring" use="required">
        <xsd:annotation>
            <xsd:documentation>QueryTable Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="headers" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>First Row Column Titles</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowNumbers" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Row Numbers</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="disableRefresh" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Disable Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="backgroundRefresh" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Background Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="firstBackgroundRefresh" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>First Background Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshOnLoad" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Refresh On Load</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="growShrinkType" type="ST_GrowShrinkType" use="optional" default="insertDelete">
        <xsd:annotation>
            <xsd:documentation>Grow Shrink Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fillFormulas" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Fill Adjacent Formulas</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="removeDataOnSave" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Remove Data On Save</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="disableEdit" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Disable Edit</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="preserveFormatting" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Preserve Formatting On Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="adjustColumnWidth" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Adjust Column Width On Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="intermediate" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Intermediate</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="connectionId" type="xsd:unsignedInt" use="required">
        <xsd:annotation>
            <xsd:documentation>Connection Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attributeGroup ref="AG_AutoFormat" />
</xsd:complexType>
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:
Collapse References:
nsM:queryTable
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0