QTSourceType complexType

Describes the properties of the query table on which a PivotTable view or report is based.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
DataMember Specifies the data source of the PivotTable view or report. It is set to the text "XLDataSource".
CacheFile Specifies the name of the file containing the supporting records for a PivotTable view or report.
QuerySource Describes the data source that a query table was based on when it was created from an external source.
CacheIndex Contains a unique identifier for the cache containing the supporting records for a PivotTable view or report.

Attributes

Attribute Type Required Description Possible Values
Href xsd:string required Specifies the name of the file containing the supporting records for a PivotTable view or report. See external namespace.

Definition

      
<xsd:complexType name="QTSourceType" >
  <xsd:sequence>
    <xsd:element name="DataMember" type="xsd:string" default="XLDataSource" minOccurs="0">
    </xsd:element>
    <xsd:element name="CacheFile" minOccurs="0">
      <xsd:complexType>
        <xsd:attribute name="Href" type="xsd:string" use="required">
        </xsd:attribute>
      </xsd:complexType>
    </xsd:element>
    <xsd:element name="QuerySource" type="QTQuerySourceType" minOccurs="0">
    </xsd:element>
    <xsd:element name="CacheIndex" type="xsd:integer" minOccurs="0">
    </xsd:element>
  </xsd:sequence>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp