PivotCell.MDX 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 a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source.

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

public string MDX { get; }

Public ReadOnly Property MDX As String

Property Value

String

A tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source.

Remarks

Read-only.

The dimensions returned in the tuple by the MDX property include row and column coordinates as well as report filter coordinates. For cells outside the values area of the PivotTable, and outside a PivotTable, accessing this property will generate a run-time error. For PivotTables with multi-item selection in a report filter field, accessing this property will also generate a run-time error.

Applies to