PivotTable.PivotValueCell(Object, Object) Method
Definition
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.
Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices.
public Microsoft.Office.Interop.Excel.PivotValueCell PivotValueCell (object rowline, object columnline);Public Function PivotValueCell (Optional rowline As Object, Optional columnline As Object) As PivotValueCellParameters
- rowline
- Object
If of type PivotLine, specifies the PivotLine in the row area that the PivotValueCell is aligned with. If of type Int, then specifies position of the PivotLine on the row area that the PivotValueCell is aligned with. If missing, Empty, Null, or 0 specifies the grand total row.
- columnline
- Object
If of type PivotLine, specifies the PivotLine in the column area that the PivotValueCell is aligned with. If of type Int, then specifies position of the PivotLine on the column area that the PivotValueCell is aligned with. If missing, Empty, Null or 0, specifies the grand total column.