CalculatedMember.SourceName Property
Returns the specified object’s name as it appears in the original source data for the specified PivotTable report.
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 CalculatedMember
Dim value As String
value = instance.SourceName
string SourceName { get; }
Property Value
Type: System.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 data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".
Property |
Value (OLAP data source) |
Value (non-OLAP data source) |
|---|---|---|
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.
Syntax (OLAP data source) |
Syntax (non-OLAP data source) |
|---|---|
expression.PivotItems("[Europe].[France].[Paris]") |
expression.PivotItems("Paris") |
When using the Item property to reference a specific member of a collection, you can use the text index names, as shown in the following table.
Name (OLAP data source) |
Name (non-OLAP data source) |
|---|---|
[Europe].[France].[Paris] |
Paris |