Definition Type: Element
Name: QuerySource
Namespace: urn:schemas-microsoft-com:office:excel
Type: x:PTQuerySourceType
Containing Schema: excel.xsd
MinOccurs 0
MaxOccurs (1)
Abstract
Documentation:
Describes the data source that the PivotTable view is based on when the PivotTable view is created from an external source.
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_xsd Drilldown into PTQuerySourceType in schema excel_xsdXSD Diagram of QuerySource in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="QuerySource" type="PTQuerySourceType" minOccurs="0">
    <xsd:annotation>
        <xsd:documentation>Describes the data source that the PivotTable view is based on when the PivotTable view is created from an external source.</xsd:documentation>
    </xsd:annotation>
</xsd:element>
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: