SlicerCache.SourceName Property
Gets the name of the data source the slicer is connected to.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property SourceName As String
Get
'Usage
Dim instance As SlicerCache
Dim value As String
value = instance.SourceName
string SourceName { get; }
Property Value
Type: System.String
The name of the data source the slicer is connected to.
Remarks
Read-only.
For slicers based on data in the workbook (SlicerCache.SourceType = xlDatabase), or slicers based on non-OLAP external data (SlicerCache.SourceType = xlExternal and SlicerCache.OLAP = false), returns the name of the corresponding column in the source data.
For OLAP slicers (SlicerCache.OLAP = true), returns the MDX unique name of the hierarchy the slicer is based on.