SlicerCache.SourceName Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Gets the name of the data source the slicer is connected to.

public:
 property System::String ^ SourceName { System::String ^ get(); };

public string SourceName { get; }

Public ReadOnly Property SourceName As String

Property Value

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.