Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: QTSourceType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Describes the properties of the query table on which a PivotTable view or report is based.
Collapse XSD Schema Diagram:
Drilldown into CacheIndex in schema excel_xsd Drilldown into QuerySource in schema excel_xsd Drilldown into CacheFile in schema excel_xsd Drilldown into DataMember in schema excel_xsdXSD Diagram of QTSourceType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="QTSourceType">
    <xsd:annotation>
        <xsd:documentation>Describes the properties of the query table on which a PivotTable view or report is based.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="DataMember" type="xsd:string" default="XLDataSource" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the data source of the PivotTable view or report. It is set to the text "XLDataSource".</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CacheFile" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the file containing the supporting records for a PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute name="Href" type="xsd:string" use="required">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the name of the file containing the supporting records for a PivotTable view or report.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="QuerySource" type="QTQuerySourceType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Describes the data source that a query table was based on when it was created from an external source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CacheIndex" type="xsd:integer" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a unique identifier for the cache containing the supporting records for a PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
DataMember x:DataMember 0 (1)
CacheFile x:CacheFile 0 (1)
QuerySource x:QuerySource 0 (1)
CacheIndex x:CacheIndex 0 (1)
Collapse Derivation Tree:
Collapse References:
x:QTSource
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0