# GrapeCity.Documents.Excel.IWorksheets

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IWorksheets" data-uid="GrapeCity.Documents.Excel.IWorksheets" class="text-break">IWorksheets Interface
</h1>
  <div class="markdown level0 summary"><p>Represents a collection of all the sheets in the workbook.</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_IWorksheets_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IWorksheets : IEnumerable&lt;IWorksheet&gt;, IEnumerable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IWorksheets
    Inherits IEnumerable(Of IWorksheet), 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_IWorksheets_Count" data-uid="GrapeCity.Documents.Excel.IWorksheets.Count">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Count.html#GrapeCity_Documents_Excel_IWorksheets_Count">Count</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the number of objects in the collection (read-only).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Item_System_Int32_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Item(System.Int32)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Item.html#GrapeCity_Documents_Excel_IWorksheets_Item_System_Int32_">this[int]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the worksheet using the index.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Item_System_String_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Item(System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Item.html#GrapeCity_Documents_Excel_IWorksheets_Item_System_String_">this[string]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the worksheet using the name.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Item_System_String___" data-uid="GrapeCity.Documents.Excel.IWorksheets.Item(System.String[])">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Item.html#GrapeCity_Documents_Excel_IWorksheets_Item_System_String___">this[string[]]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets worksheets by names.</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_IWorksheets_Add" data-uid="GrapeCity.Documents.Excel.IWorksheets.Add">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Add.html#GrapeCity_Documents_Excel_IWorksheets_Add">Add()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new worksheet. The new worksheet becomes the active sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Add_GrapeCity_Documents_Excel_SheetType_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Add(GrapeCity.Documents.Excel.SheetType)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Add.html#GrapeCity_Documents_Excel_IWorksheets_Add_GrapeCity_Documents_Excel_SheetType_">Add(SheetType)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new sheet. The new sheet becomes the active sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_AddAfter_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.AddAfter(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.AddAfter.html#GrapeCity_Documents_Excel_IWorksheets_AddAfter_GrapeCity_Documents_Excel_IWorksheet_">AddAfter(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new worksheet and inserts it after the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_AddBefore_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.AddBefore(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.AddBefore.html#GrapeCity_Documents_Excel_IWorksheets_AddBefore_GrapeCity_Documents_Excel_IWorksheet_">AddBefore(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new worksheet and inserts it before the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Contains_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Contains(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Contains.html#GrapeCity_Documents_Excel_IWorksheets_Contains_GrapeCity_Documents_Excel_IWorksheet_">Contains(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns true if the specified Worksheet is contained by the collection of worksheets; otherwise, false is returned.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Copy_GrapeCity_Documents_Excel_IWorkbook_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Copy(GrapeCity.Documents.Excel.IWorkbook)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Copy.html#GrapeCity_Documents_Excel_IWorksheets_Copy_GrapeCity_Documents_Excel_IWorkbook_">Copy(IWorkbook)</a>
        </td>
        <td class="markdown level1 summary"><p>Copies the sheet collection to the end of the specified workbook.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_CopyAfter_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.CopyAfter(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.CopyAfter.html#GrapeCity_Documents_Excel_IWorksheets_CopyAfter_GrapeCity_Documents_Excel_IWorksheet_">CopyAfter(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Copies the sheet collection to the location after the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_CopyBefore_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.CopyBefore(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.CopyBefore.html#GrapeCity_Documents_Excel_IWorksheets_CopyBefore_GrapeCity_Documents_Excel_IWorksheet_">CopyBefore(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Copies the sheet collection to the location before the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_IndexOf_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.IndexOf(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.IndexOf.html#GrapeCity_Documents_Excel_IWorksheets_IndexOf_GrapeCity_Documents_Excel_IWorksheet_">IndexOf(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns the zero-based index of the specified worksheet in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Move_GrapeCity_Documents_Excel_IWorkbook_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Move(GrapeCity.Documents.Excel.IWorkbook)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Move.html#GrapeCity_Documents_Excel_IWorksheets_Move_GrapeCity_Documents_Excel_IWorkbook_">Move(IWorkbook)</a>
        </td>
        <td class="markdown level1 summary"><p>Moves the sheet collection to the end of the specified workbook.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_MoveAfter_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.MoveAfter(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.MoveAfter.html#GrapeCity_Documents_Excel_IWorksheets_MoveAfter_GrapeCity_Documents_Excel_IWorksheet_">MoveAfter(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Moves the sheet collection to the location after the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_MoveBefore_GrapeCity_Documents_Excel_IWorksheet_" data-uid="GrapeCity.Documents.Excel.IWorksheets.MoveBefore(GrapeCity.Documents.Excel.IWorksheet)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.MoveBefore.html#GrapeCity_Documents_Excel_IWorksheets_MoveBefore_GrapeCity_Documents_Excel_IWorksheet_">MoveBefore(IWorksheet)</a>
        </td>
        <td class="markdown level1 summary"><p>Moves the sheet collection to the location before the specified sheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheets_Select_System_Boolean_" data-uid="GrapeCity.Documents.Excel.IWorksheets.Select(System.Boolean)">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheets.Select.html#GrapeCity_Documents_Excel_IWorksheets_Select_System_Boolean_">Select(bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Selects the object.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>