Share via


PivotCache.SourceData Property

Returns the data source for the PivotTable report.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property SourceData As Object
    Get
    Set
'Usage
Dim instance As PivotCache
Dim value As Object

value = instance.SourceData

instance.SourceData = value
Object SourceData { get; set; }

Property Value

Type: System.Object

Remarks

The following table shows the values returned by the SourceDate property:

Data source

Return value

Microsoft Excel list or database

The cell reference as text.

External data source

An array. Each row consists of a SQL connection string with the remaining elements as the query string, broken down into 255-character segments.

Multiple consolidation ranges

A two-dimensional array. Each row consists of a reference and its associated page field items.

Another PivotTable report

One of the above three kinds of information.

This property is not available for OLE DB data sources.

See Also

Reference

PivotCache Interface

PivotCache Members

Microsoft.Office.Interop.Excel Namespace