PivotTable.GetData Method
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.StringRequired 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