SlicerCache.SourceName Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

Applies to