Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PTQuerySourceType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Describes the data source on which the query table or PivotTable is based.
Collapse XSD Schema Diagram:
Drilldown into VersionRefreshableMin in schema excel_xsd Drilldown into VersionLastRefresh in schema excel_xsd Drilldown into VersionLastEdit in schema excel_xsd Drilldown into UseLocalConnection in schema excel_xsd Drilldown into NoRefreshCache in schema excel_xsd Drilldown into LocalConnection in schema excel_xsd Drilldown into RefreshTimeSpan in schema excel_xsd Drilldown into RobustConnect in schema excel_xsd Drilldown into SourceDataFile in schema excel_xsd Drilldown into SourceConnectionFile in schema excel_xsd Drilldown into CommandTextOrignal in schema excel_xsd Drilldown into Parameter in schema excel_xsd Drilldown into Connection in schema excel_xsd Drilldown into Maintain in schema excel_xsd Drilldown into CommandType in schema excel_xsd Drilldown into CommandText in schema excel_xsd Drilldown into QueryType in schema excel_xsdXSD Diagram of PTQuerySourceType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PTQuerySourceType">
    <xsd:annotation>
        <xsd:documentation>Describes the data source on which the query table or PivotTable is based.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="QueryType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the query mechanism to use.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Access" />
                    <xsd:enumeration value="ADO" />
                    <xsd:enumeration value="ODBC" />
                    <xsd:enumeration value="OLEDB" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="CommandText" type="xsd:string" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the text of the command to submit to the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CommandType" default="None" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the type of command used in the CommandText element.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="Cube" />
                    <xsd:enumeration value="Default" />
                    <xsd:enumeration value="None" />
                    <xsd:enumeration value="SQL" />
                    <xsd:enumeration value="Table" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="Maintain" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that a connection to the data source be left open after data is retrieved.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Connection" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text that defines the connection to the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Parameter" type="ParameterTypeE" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the parameters to the command text.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CommandTextOrignal" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the original text of the command to submit to the data source. Used only for PivotTable views when server-based page fields are used.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceConnectionFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the  name of the query file that was used to query the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceDataFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains the name of source data file (such as an .mdb file) from which the data for the PivotTable view was originally retrieved.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RobustConnect" type="OneZeroType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an enumeration indicating what to do when re-establishing a connection if a refresh fails.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshTimeSpan" type="xsd:integer" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies how often (in minutes) a PivotTable view or report should be refreshed.  A value of zero indicates that timed or automatic refreshing of data is turned off.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LocalConnection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Specifies the text that defines the connection to the local cube slice on the client computer.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoRefreshCache" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a boolean indicating if the cube can be refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="UseLocalConnection" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean indicating if the user is currently using the local cube slice.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastEdit" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating what version of Excel last edited the data from the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastRefresh" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating what version of Excel last refreshed the PivotTable view or query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionRefreshableMin" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a number indicating the earliest version of Excel that can refresh the PivotTable view or query table.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
QueryType x:QueryType 0 (1)
CommandText x:CommandText (1) unbounded
CommandType x:CommandType 0 (1)
Maintain x:Maintain 0 (1)
Connection x:Connection 0 (1)
Parameter x:Parameter 0 unbounded
CommandTextOrignal x:CommandTextOrignal 0 unbounded
SourceConnectionFile x:SourceConnectionFile 0 unbounded
SourceDataFile x:SourceDataFile 0 unbounded
RobustConnect x:RobustConnect 0 (1)
RefreshTimeSpan x:RefreshTimeSpan 0 (1)
LocalConnection x:LocalConnection 0 unbounded
NoRefreshCache x:NoRefreshCache 0 (1)
UseLocalConnection x:UseLocalConnection 0 (1)
VersionLastEdit x:VersionLastEdit 0 (1)
VersionLastRefresh x:VersionLastRefresh 0 (1)
VersionRefreshableMin x:VersionRefreshableMin 0 (1)
Collapse Derivation Tree:
Collapse References:
x:QuerySource
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0