PivotTable.GetData Method

  • Article

Returns data from the specified PivotTable cell.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function GetData ( _
    Name As String _
) As Double
'Usage
Dim instance As PivotTable
Dim Name As String
Dim returnValue As Double

returnValue = instance.GetData(Name)

double GetData(
    string Name
)

Parameters

  • Name
    Type: System.String

    Required String. Describes a single cell in the PivotTable report, using syntax similar to the PivotSelect method or the PivotTable report references in calculated item formulas.

Return Value

Type: System.Double

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace