# GrapeCity.Documents.Excel.IPivotCache

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IPivotCache" data-uid="GrapeCity.Documents.Excel.IPivotCache" class="text-break">IPivotCache Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the memory cache for a 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_IPivotCache_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IPivotCache</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IPivotCache</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_IPivotCache_Index" data-uid="GrapeCity.Documents.Excel.IPivotCache.Index">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.Index.html#GrapeCity_Documents_Excel_IPivotCache_Index">Index</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the index number of the object within the collection of similar objects.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_RecordCount" data-uid="GrapeCity.Documents.Excel.IPivotCache.RecordCount">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.RecordCount.html#GrapeCity_Documents_Excel_IPivotCache_RecordCount">RecordCount</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_RefreshDate" data-uid="GrapeCity.Documents.Excel.IPivotCache.RefreshDate">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.RefreshDate.html#GrapeCity_Documents_Excel_IPivotCache_RefreshDate">RefreshDate</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the date on which the PivotTable cache was last refreshed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_RefreshName" data-uid="GrapeCity.Documents.Excel.IPivotCache.RefreshName">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.RefreshName.html#GrapeCity_Documents_Excel_IPivotCache_RefreshName">RefreshName</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the name of the person who last refreshed the PivotTable cache.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_RefreshOnFileOpen" data-uid="GrapeCity.Documents.Excel.IPivotCache.RefreshOnFileOpen">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.RefreshOnFileOpen.html#GrapeCity_Documents_Excel_IPivotCache_RefreshOnFileOpen">RefreshOnFileOpen</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened.
Defalut is false.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_SourceData" data-uid="GrapeCity.Documents.Excel.IPivotCache.SourceData">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.SourceData.html#GrapeCity_Documents_Excel_IPivotCache_SourceData">SourceData</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data source for the PivotTable report.</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_IPivotCache_CreatePivotTable_GrapeCity_Documents_Excel_IRange_System_String_" data-uid="GrapeCity.Documents.Excel.IPivotCache.CreatePivotTable(GrapeCity.Documents.Excel.IRange,System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.CreatePivotTable.html#GrapeCity_Documents_Excel_IPivotCache_CreatePivotTable_GrapeCity_Documents_Excel_IRange_System_String_">CreatePivotTable(IRange, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a PivotTable report based on a PivotCache object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotCache_Refresh" data-uid="GrapeCity.Documents.Excel.IPivotCache.Refresh">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotCache.Refresh.html#GrapeCity_Documents_Excel_IPivotCache_Refresh">Refresh()</a>
        </td>
        <td class="markdown level1 summary"><p>Updates the cache of the PivotTable object.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>