Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: QueryTableType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the properties of a query table in a worksheet.
Collapse XSD Schema Diagram:
Drilldown into Synchronous in schema excel_xsd Drilldown into RowNumbers in schema excel_xsd Drilldown into RefreshOnFileOpen in schema excel_xsd Drilldown into RefreshInfo in schema excel_xsd Drilldown into OverwriteCells in schema excel_xsd Drilldown into NoTitles in schema excel_xsd Drilldown into NoSaveData in schema excel_xsd Drilldown into NoPreserveFormatting in schema excel_xsd Drilldown into NoAutofit in schema excel_xsd Drilldown into NewAsync in schema excel_xsd Drilldown into InsertEntireRows in schema excel_xsd Drilldown into Filled in schema excel_xsd Drilldown into DisableRefresh in schema excel_xsd Drilldown into DisableEdit in schema excel_xsd Drilldown into QuerySource in schema excel_xsd Drilldown into AutoFormatWidth in schema excel_xsd Drilldown into AutoFormatAlignment in schema excel_xsd Drilldown into AutoFormatPattern in schema excel_xsd Drilldown into AutoFormatBorder in schema excel_xsd Drilldown into AutoFormatNumber in schema excel_xsd Drilldown into AutoFormatName in schema excel_xsd Drilldown into AutoFormatFont in schema excel_xsd Drilldown into Name in schema excel_xsdXSD Diagram of QueryTableType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="QueryTableType">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a query table in a worksheet.</xsd:documentation>
    </xsd:annotation>
    <xsd:all>
        <xsd:element name="Name" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatFont" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the font is changed when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatName" type="AutoFormatNameType" default="PivotTableClassic" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of a predefined format.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatNumber" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether cell number formatting is changed when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatBorder" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the cell border is changed when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatPattern" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether cell pattern formatting is changed when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatAlignment" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether cell alignment is adjusted when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AutoFormatWidth" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the cell width is changed when a predefined format is applied.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="QuerySource" type="QTQuerySourceType">
            <xsd:annotation>
                <xsd:documentation>Contains information about the data source of a query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableEdit" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether editing is allowed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableRefresh" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether refreshing and editing is enabled for a query table, or whether the cache for a  PivotTable view can be refreshed by the user.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Filled" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether formulas to the right of a query table are included in new rows that are added to a query table when data is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="InsertEntireRows" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether entire rows are inserted to accommodate new data when a query table is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NewAsync" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Indicates whether the workbook was saved while the data in a query table was being refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoAutofit" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the column widths of a query table, or the height and width of a PivotList component, adjust to accommodate the data in visible columns and rows.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoPreserveFormatting" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether formatting is preserved when data is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoSaveData" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether data from a query is saved when a workbook is saved.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoTitles" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether column titles are included in a query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="OverwriteCells" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether existing cells are used to accommodate new data when a query table is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshInfo" type="RefreshInfoType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains information to be used when data is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshOnFileOpen" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the data in a PivotTable cache or query table is refreshed when a workbook is opened.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RowNumbers" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether row numbers are included in a database query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Synchronous" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether background queries are enabled.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:all>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name 0 (1)
AutoFormatFont x:AutoFormatFont 0 (1)
AutoFormatName x:AutoFormatName 0 (1)
AutoFormatNumber x:AutoFormatNumber 0 (1)
AutoFormatBorder x:AutoFormatBorder 0 (1)
AutoFormatPattern x:AutoFormatPattern 0 (1)
AutoFormatAlignment x:AutoFormatAlignment 0 (1)
AutoFormatWidth x:AutoFormatWidth 0 (1)
QuerySource x:QuerySource (1) (1)
DisableEdit x:DisableEdit 0 (1)
DisableRefresh x:DisableRefresh 0 (1)
Filled x:Filled 0 (1)
InsertEntireRows x:InsertEntireRows 0 (1)
NewAsync x:NewAsync 0 (1)
NoAutofit x:NoAutofit 0 (1)
NoPreserveFormatting x:NoPreserveFormatting 0 (1)
NoSaveData x:NoSaveData 0 (1)
NoTitles x:NoTitles 0 (1)
OverwriteCells x:OverwriteCells 0 (1)
RefreshInfo x:RefreshInfo 0 (1)
RefreshOnFileOpen x:RefreshOnFileOpen 0 (1)
RowNumbers x:RowNumbers 0 (1)
Synchronous x:Synchronous 0 (1)
Collapse Derivation Tree:
Collapse References:
x:QueryTable
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0