PivotCache.SourceDataFile Property
Returns a String indicating the source data file for the cache of the PivotTable.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property SourceDataFile As String
Get
'Usage
Dim instance As PivotCache
Dim value As String
value = instance.SourceDataFile
string SourceDataFile { get; }
Property Value
Type: System.String
Remarks
For file-based data sources (e.g. Microsoft Access) the SourceDataFile property contains a fully qualified path to the source data file. It is Null for server-based data sources (e.g. SQL Server). The SourceDataFile property is set to Null if the Connection property is changed programmatically.