# GrapeCity.Documents.Excel.ICalculatedItems

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_Documents_Excel_ICalculatedItems" data-uid="GrapeCity.Documents.Excel.ICalculatedItems" class="text-break">ICalculatedItems Interface
</h1>
  <div class="markdown level0 summary"><p>A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_ICalculatedItems_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface ICalculatedItems : IEnumerable&lt;IPivotItem&gt;, IEnumerable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface ICalculatedItems
    Inherits IEnumerable(Of IPivotItem), IEnumerable</code></pre>
  </div>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_ICalculatedItems_Count" data-uid="GrapeCity.Documents.Excel.ICalculatedItems.Count">
          <a class="xref" href="GrapeCity.Documents.Excel.ICalculatedItems.Count.html#GrapeCity_Documents_Excel_ICalculatedItems_Count">Count</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the number of <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.html">IPivotItem</a> in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ICalculatedItems_Item_System_Int32_" data-uid="GrapeCity.Documents.Excel.ICalculatedItems.Item(System.Int32)">
          <a class="xref" href="GrapeCity.Documents.Excel.ICalculatedItems.Item.html#GrapeCity_Documents_Excel_ICalculatedItems_Item_System_Int32_">this[int]</a>
        </td>
        <td class="markdown level1 summary"><p>Get <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.html">IPivotItem</a> item by index.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ICalculatedItems_Item_System_String_" data-uid="GrapeCity.Documents.Excel.ICalculatedItems.Item(System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.ICalculatedItems.Item.html#GrapeCity_Documents_Excel_ICalculatedItems_Item_System_String_">this[string]</a>
        </td>
        <td class="markdown level1 summary"><p>Get <a class="xref" href="GrapeCity.Documents.Excel.IPivotItem.html">IPivotItem</a> item by name.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_ICalculatedItems_Add_System_String_System_String_" data-uid="GrapeCity.Documents.Excel.ICalculatedItems.Add(System.String,System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.ICalculatedItems.Add.html#GrapeCity_Documents_Excel_ICalculatedItems_Add_System_String_System_String_">Add(string, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new calculated item. Returns a PivotItem object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_ICalculatedItems_Remove_System_String_" data-uid="GrapeCity.Documents.Excel.ICalculatedItems.Remove(System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.ICalculatedItems.Remove.html#GrapeCity_Documents_Excel_ICalculatedItems_Remove_System_String_">Remove(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Remove calculated item.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
