# GrapeCity.Documents.Excel.PrintManager.Paginate

## Content

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



<h1 id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*">Paginate Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*"></a>
<h4 id="GrapeCity_Documents_Excel_PrintManager_Paginate_System_Collections_Generic_IEnumerable_GrapeCity_Documents_Excel_IWorkbook__" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate(System.Collections.Generic.IEnumerable{GrapeCity.Documents.Excel.IWorkbook})">Paginate(IEnumerable&lt;IWorkbook&gt;)</h4>
<div class="markdown level1 summary"><p>Generate pagination informations for all worksheets in all workbooks.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public IList&lt;PageInfo&gt; Paginate(IEnumerable&lt;IWorkbook&gt; workbooks)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Paginate(workbooks As IEnumerable(Of IWorkbook)) As IList(Of PageInfo)</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.collections.generic.ienumerable-1">IEnumerable</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.IWorkbook.html">IWorkbook</a>&gt;</td>
      <td><span class="parametername">workbooks</span></td>
      <td><p>The collection of workbooks.</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="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.PageInfo.html">PageInfo</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*"></a>
<h4 id="GrapeCity_Documents_Excel_PrintManager_Paginate_GrapeCity_Documents_Excel_IWorkbook_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate(GrapeCity.Documents.Excel.IWorkbook)">Paginate(IWorkbook)</h4>
<div class="markdown level1 summary"><p>Generate pagination informations for all worksheets in the workbook.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public IList&lt;PageInfo&gt; Paginate(IWorkbook workbook)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Paginate(workbook As IWorkbook) As IList(Of PageInfo)</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="GrapeCity.Documents.Excel.IWorkbook.html">IWorkbook</a></td>
      <td><span class="parametername">workbook</span></td>
      <td><p>The workbook object.</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="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.PageInfo.html">PageInfo</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*"></a>
<h4 id="GrapeCity_Documents_Excel_PrintManager_Paginate_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate(GrapeCity.Documents.Excel.IWorksheet)">Paginate(IWorksheet)</h4>
<div class="markdown level1 summary"><p>Generate pagination information for the worksheet.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public IList&lt;PageInfo&gt; Paginate(IWorksheet worksheet)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Paginate(worksheet As IWorksheet) As IList(Of PageInfo)</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="GrapeCity.Documents.Excel.IWorksheet.html">IWorksheet</a></td>
      <td><span class="parametername">worksheet</span></td>
      <td><p>The worksheet object.</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="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.PageInfo.html">PageInfo</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*"></a>
<h4 id="GrapeCity_Documents_Excel_PrintManager_Paginate_GrapeCity_Documents_Excel_IWorksheet_System_Collections_Generic_IList_GrapeCity_Documents_Excel_IRange__System_Collections_Generic_IList_GrapeCity_Documents_Excel_RepeatSetting__" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate(GrapeCity.Documents.Excel.IWorksheet,System.Collections.Generic.IList{GrapeCity.Documents.Excel.IRange},System.Collections.Generic.IList{GrapeCity.Documents.Excel.RepeatSetting})">Paginate(IWorksheet, IList&lt;IRange&gt;, IList&lt;RepeatSetting&gt;)</h4>
<div class="markdown level1 summary"><p>Generate pagination information for the worksheet.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public IList&lt;PageInfo&gt; Paginate(IWorksheet worksheet, IList&lt;IRange&gt; keepTogetherRanges, IList&lt;RepeatSetting&gt; repeatSettings)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Paginate(worksheet As IWorksheet, keepTogetherRanges As IList(Of IRange), repeatSettings As IList(Of RepeatSetting)) As IList(Of PageInfo)</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="GrapeCity.Documents.Excel.IWorksheet.html">IWorksheet</a></td>
      <td><span class="parametername">worksheet</span></td>
      <td><p>The worksheet object.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.IRange.html">IRange</a>&gt;</td>
      <td><span class="parametername">keepTogetherRanges</span></td>
      <td><p>The collection of ranges that need to keep together.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.RepeatSetting.html">RepeatSetting</a>&gt;</td>
      <td><span class="parametername">repeatSettings</span></td>
      <td><p>The collection of repeat settings for a Range.</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="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.PageInfo.html">PageInfo</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>


<a id="GrapeCity_Documents_Excel_PrintManager_Paginate_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate*"></a>
<h4 id="GrapeCity_Documents_Excel_PrintManager_Paginate_GrapeCity_Documents_Excel_IRange_" data-uid="GrapeCity.Documents.Excel.PrintManager.Paginate(GrapeCity.Documents.Excel.IRange)">Paginate(IRange)</h4>
<div class="markdown level1 summary"><p>Generate pagination information for the range.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public IList&lt;PageInfo&gt; Paginate(IRange printArea)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Function Paginate(printArea As IRange) As IList(Of PageInfo)</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="GrapeCity.Documents.Excel.IRange.html">IRange</a></td>
      <td><span class="parametername">printArea</span></td>
      <td><p>The area will be paginated.</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="https://learn.microsoft.com/dotnet/api/system.collections.generic.ilist-1">IList</a>&lt;<a class="xref" href="GrapeCity.Documents.Excel.PageInfo.html">PageInfo</a>&gt;</td>
      <td></td>
    </tr>
  </tbody>
</table>
</div>