CalculatedMember.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.

Returns the specified object’s name as it appears in the original source data for the specified PivotTable report.

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

public string SourceName { get; }

Public ReadOnly Property SourceName As String

Property Value

String

Remarks

The SourceName property might be different from the current item name if the user renamed the item after creating the PivotTable report.

The following table shows example values of the SourceName property and related properties, given an OLAP

Caption	Paris	Paris
Name	[Europe].[France].[Paris] (read-only)	Paris
SourceName	[Europe].[France].[Paris] (read-only)	(same as SQL property value, read-only)
Value	[Europe].[France].[Paris] (read-only)	Paris

When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.

expression.PivotItems("[Europe].[France].[Paris]")

expression.PivotItems("Paris")

When using the Item[Object] property to reference a specific member of a collection, you can use the text index names, as shown in the following table.

[Europe].[France].[Paris]

Paris

Applies to