# GrapeCity.Documents.Excel.IPivotTable.PivotValueCell

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Documents_Excel_IPivotTable_PivotValueCell_" data-uid="GrapeCity.Documents.Excel.IPivotTable.PivotValueCell*">PivotValueCell Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IPivotTable_PivotValueCell_" data-uid="GrapeCity.Documents.Excel.IPivotTable.PivotValueCell*"></a>
<h4 id="GrapeCity_Documents_Excel_IPivotTable_PivotValueCell_System_Int32_System_Int32_" data-uid="GrapeCity.Documents.Excel.IPivotTable.PivotValueCell(System.Int32,System.Int32)">PivotValueCell(int, int)</h4>
<div class="markdown level1 summary"><p>Retrieves the <a class="xref" href="GrapeCity.Documents.Excel.IPivotValueCell.html">IPivotValueCell</a> at the specified row and column position in the PivotTable data area.</p>
<p>
Use this method to access a calculated value cell in a PivotTable report and then inspect
its value or related <a class="xref" href="GrapeCity.Documents.Excel.IPivotCell.html">IPivotCell</a> information.
</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">IPivotValueCell PivotValueCell(int rowline, int columnline)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Function PivotValueCell(rowline As Integer, columnline As Integer) As IPivotValueCell</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">rowline</span></td>
      <td><p>The row position in the data area.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">columnline</span></td>
      <td><p>The column position in the data area.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Documents.Excel.IPivotValueCell.html">IPivotValueCell</a></td>
      <td><p>The <a class="xref" href="GrapeCity.Documents.Excel.IPivotValueCell.html">IPivotValueCell</a> at the specified row and column position in the data area.</p>
</td>
    </tr>
  </tbody>
</table>
<h5 id="GrapeCity_Documents_Excel_IPivotTable_PivotValueCell_System_Int32_System_Int32__examples">Examples</h5>
<pre><code class="lang-csharp">worksheet.Range["A1:B3"].Value = new object[,] {
    {"Region", "Amount"},
    {"East", 100},
    {"West", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"]);
pivotTable.PivotFields["Region"].Orientation = PivotFieldOrientation.RowField;
pivotTable.PivotFields["Amount"].Orientation = PivotFieldOrientation.DataField;
IPivotValueCell valueCell = pivotTable.PivotValueCell(0, 0);
object value = valueCell.Value;</code></pre>

</div>