QTSource element

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

Usage

      
<QTSource
	Href="xsd:string"
/>

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
PivotTable Contains information about a PivotTable view.

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:element name="QTSource" type="QTSourceType" minOccurs="0" >
</xsd:element>


    
©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