# C1.Excel.XLExternalBookCollection

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_Excel_XLExternalBookCollection" data-uid="C1.Excel.XLExternalBookCollection" class="text-break">XLExternalBookCollection Class
</h1>
  <div class="markdown level0 summary"><p>Collection of <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> objects that represent the individual
worksheets in a <a class="xref" href="C1.Excel.C1XLBook.html">C1XLBook</a>.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">XLExternalBookCollection</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.collections.ienumerable">IEnumerable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.Excel.html">C1.Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.Excel.dll</h6>
  <h5 id="C1_Excel_XLExternalBookCollection_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLExternalBookCollection : IEnumerable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLExternalBookCollection
    Implements 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="C1_Excel_XLExternalBookCollection_Book" data-uid="C1.Excel.XLExternalBookCollection.Book">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Book.html#C1_Excel_XLExternalBookCollection_Book">Book</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a reference to the <a class="xref" href="C1.Excel.C1XLBook.html">C1XLBook</a> that owns the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Count" data-uid="C1.Excel.XLExternalBookCollection.Count">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Count.html#C1_Excel_XLExternalBookCollection_Count">Count</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> objects in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Item_System_Int32_" data-uid="C1.Excel.XLExternalBookCollection.Item(System.Int32)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Item.html#C1_Excel_XLExternalBookCollection_Item_System_Int32_">this[int]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="C1.Excel.XLSheet.html">XLSheet</a> at a given position in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Item_System_String_" data-uid="C1.Excel.XLExternalBookCollection.Item(System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Item.html#C1_Excel_XLExternalBookCollection_Item_System_String_">this[string]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="C1.Excel.XLSheet.html">XLSheet</a> with the given name (case-insensitive).</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="C1_Excel_XLExternalBookCollection_Add_C1_Excel_XLExternalBook_" data-uid="C1.Excel.XLExternalBookCollection.Add(C1.Excel.XLExternalBook)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Add.html#C1_Excel_XLExternalBookCollection_Add_C1_Excel_XLExternalBook_">Add(XLExternalBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Appends an existing <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> to the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Add_System_String_" data-uid="C1.Excel.XLExternalBookCollection.Add(System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Add.html#C1_Excel_XLExternalBookCollection_Add_System_String_">Add(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> with a given name and appends it to the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Clear" data-uid="C1.Excel.XLExternalBookCollection.Clear">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Clear.html#C1_Excel_XLExternalBookCollection_Clear">Clear()</a>
        </td>
        <td class="markdown level1 summary"><p>Removes all items from the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Contains_C1_Excel_XLExternalBook_" data-uid="C1.Excel.XLExternalBookCollection.Contains(C1.Excel.XLExternalBook)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Contains.html#C1_Excel_XLExternalBookCollection_Contains_C1_Excel_XLExternalBook_">Contains(XLExternalBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the collection contains a specific <a class="xref" href="C1.Excel.XLSheet.html">XLSheet</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Contains_System_String_" data-uid="C1.Excel.XLExternalBookCollection.Contains(System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Contains.html#C1_Excel_XLExternalBookCollection_Contains_System_String_">Contains(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the collection contains an <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> object
with a given name.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_IndexOf_C1_Excel_XLExternalBook_" data-uid="C1.Excel.XLExternalBookCollection.IndexOf(C1.Excel.XLExternalBook)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.IndexOf.html#C1_Excel_XLExternalBookCollection_IndexOf_C1_Excel_XLExternalBook_">IndexOf(XLExternalBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of a given <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_IndexOf_System_String_" data-uid="C1.Excel.XLExternalBookCollection.IndexOf(System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.IndexOf.html#C1_Excel_XLExternalBookCollection_IndexOf_System_String_">IndexOf(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the position of the sheet with the specified name in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Insert_System_Int32_C1_Excel_XLExternalBook_" data-uid="C1.Excel.XLExternalBookCollection.Insert(System.Int32,C1.Excel.XLExternalBook)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Insert.html#C1_Excel_XLExternalBookCollection_Insert_System_Int32_C1_Excel_XLExternalBook_">Insert(int, XLExternalBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Inserts an <a class="xref" href="C1.Excel.XLSheet.html">XLSheet</a> object into the collection at the specified position.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Insert_System_Int32_System_String_" data-uid="C1.Excel.XLExternalBookCollection.Insert(System.Int32,System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Insert.html#C1_Excel_XLExternalBookCollection_Insert_System_Int32_System_String_">Insert(int, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> and inserts it at a specific
position in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Remove_C1_Excel_XLExternalBook_" data-uid="C1.Excel.XLExternalBookCollection.Remove(C1.Excel.XLExternalBook)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Remove.html#C1_Excel_XLExternalBookCollection_Remove_C1_Excel_XLExternalBook_">Remove(XLExternalBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes an <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> from the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_Remove_System_String_" data-uid="C1.Excel.XLExternalBookCollection.Remove(System.String)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.Remove.html#C1_Excel_XLExternalBookCollection_Remove_System_String_">Remove(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes the <a class="xref" href="C1.Excel.XLExternalBook.html">XLExternalBook</a> with the specified name from the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLExternalBookCollection_RemoveAt_System_Int32_" data-uid="C1.Excel.XLExternalBookCollection.RemoveAt(System.Int32)">
          <a class="xref" href="C1.Excel.XLExternalBookCollection.RemoveAt.html#C1_Excel_XLExternalBookCollection_RemoveAt_System_Int32_">RemoveAt(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes the <a class="xref" href="C1.Excel.XLSheet.html">XLSheet</a> at a specific index from the collection.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
