# C1.C1Excel.XLCellRangeCollection

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_C1Excel_XLCellRangeCollection" data-uid="C1.C1Excel.XLCellRangeCollection" class="text-break">XLCellRangeCollection Class
</h1>
  <div class="markdown level0 summary"><p>Represents a collection of <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> objects on
an <a class="xref" href="C1.C1Excel.XLSheet.html">XLSheet</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">XLCellRangeCollection</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.C1Excel.html">C1.C1Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.C1Excel.4.8.dll</h6>
  <h5 id="C1_C1Excel_XLCellRangeCollection_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLCellRangeCollection : IEnumerable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLCellRangeCollection
    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_C1Excel_XLCellRangeCollection_ActiveIndex" data-uid="C1.C1Excel.XLCellRangeCollection.ActiveIndex">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.ActiveIndex.html#C1_C1Excel_XLCellRangeCollection_ActiveIndex">ActiveIndex</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the active index in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Book" data-uid="C1.C1Excel.XLCellRangeCollection.Book">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Book.html#C1_C1Excel_XLCellRangeCollection_Book">Book</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a reference to the parent <a class="xref" href="C1.C1Excel.C1XLBook.html">C1XLBook</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Count" data-uid="C1.C1Excel.XLCellRangeCollection.Count">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Count.html#C1_C1Excel_XLCellRangeCollection_Count">Count</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> objects in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Item_System_Int32_" data-uid="C1.C1Excel.XLCellRangeCollection.Item(System.Int32)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Item.html#C1_C1Excel_XLCellRangeCollection_Item_System_Int32_">this[int]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object at the specified position in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Sheet" data-uid="C1.C1Excel.XLCellRangeCollection.Sheet">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Sheet.html#C1_C1Excel_XLCellRangeCollection_Sheet">Sheet</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="C1.C1Excel.XLSheet.html">XLSheet</a> object that owns the collection.</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_C1Excel_XLCellRangeCollection_Add_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.Add(C1.C1Excel.XLCellRange)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Add.html#C1_C1Excel_XLCellRangeCollection_Add_C1_C1Excel_XLCellRange_">Add(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Appends an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object to the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Add_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="C1.C1Excel.XLCellRangeCollection.Add(System.Int32,System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Add.html#C1_C1Excel_XLCellRangeCollection_Add_System_Int32_System_Int32_System_Int32_System_Int32_">Add(int, int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object and appends it to the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Clear" data-uid="C1.C1Excel.XLCellRangeCollection.Clear">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Clear.html#C1_C1Excel_XLCellRangeCollection_Clear">Clear()</a>
        </td>
        <td class="markdown level1 summary"><p>Removes all <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> objects from the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Contains_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.Contains(C1.C1Excel.XLCellRange)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Contains.html#C1_C1Excel_XLCellRangeCollection_Contains_C1_C1Excel_XLCellRange_">Contains(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Checks whether the collection contains a specific <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_IndexOf_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.IndexOf(C1.C1Excel.XLCellRange)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.IndexOf.html#C1_C1Excel_XLCellRangeCollection_IndexOf_C1_C1Excel_XLCellRange_">IndexOf(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the position of an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object in the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Insert_System_Int32_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.Insert(System.Int32,C1.C1Excel.XLCellRange)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Insert.html#C1_C1Excel_XLCellRangeCollection_Insert_System_Int32_C1_C1Excel_XLCellRange_">Insert(int, XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Inserts an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object at a specific position in the
collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_Remove_C1_C1Excel_XLCellRange_" data-uid="C1.C1Excel.XLCellRangeCollection.Remove(C1.C1Excel.XLCellRange)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.Remove.html#C1_C1Excel_XLCellRangeCollection_Remove_C1_C1Excel_XLCellRange_">Remove(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object from the collection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLCellRangeCollection_RemoveAt_System_Int32_" data-uid="C1.C1Excel.XLCellRangeCollection.RemoveAt(System.Int32)">
          <a class="xref" href="C1.C1Excel.XLCellRangeCollection.RemoveAt.html#C1_C1Excel_XLCellRangeCollection_RemoveAt_System_Int32_">RemoveAt(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes an <a class="xref" href="C1.C1Excel.XLCellRange.html">XLCellRange</a> object at a specific position from the collection.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
