# C1.WPF.Excel.XLCellRange

## Content

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



  <h1 id="C1_WPF_Excel_XLCellRange" data-uid="C1.WPF.Excel.XLCellRange" class="text-break">XLCellRange Class
</h1>
  <div class="markdown level0 summary"><p>Represents a range of <a class="xref" href="C1.WPF.Excel.XLCell.html">XLCell</a> objects in an <a class="xref" href="C1.WPF.Excel.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">XLCellRange</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="C1.WPF.Excel.ICloneable.html">ICloneable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.WPF.Excel.html">C1.WPF.Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.WPF.Excel.4.6.2.dll</h6>
  <h5 id="C1_WPF_Excel_XLCellRange_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLCellRange : ICloneable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLCellRange
    Implements ICloneable</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor" data-uid="C1.WPF.Excel.XLCellRange.#ctor">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor">XLCellRange()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing
an empty range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_C1XLBook_System_String_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(C1.WPF.Excel.C1XLBook,System.String)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_C1XLBook_System_String_">XLCellRange(C1XLBook, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(C1.WPF.Excel.XLSheet,System.Int32,System.Int32,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_">XLCellRange(XLSheet, int, int, XLReferenceType, XLReferenceType)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(C1.WPF.Excel.XLSheet,System.Int32,System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_System_Int32_System_Int32_">XLCellRange(XLSheet, int, int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(C1.WPF.Excel.XLSheet,System.Int32,System.Int32,System.Int32,System.Int32,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_">XLCellRange(XLSheet, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_String_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(C1.WPF.Excel.XLSheet,System.String)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_C1_WPF_Excel_XLSheet_System_String_">XLCellRange(XLSheet, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_System_Int32_System_Int32_System_Int32_System_Int32_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(System.Int32,System.Int32,System.Int32,System.Int32)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_System_Int32_System_Int32_System_Int32_System_Int32_">XLCellRange(int, int, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange__ctor_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_" data-uid="C1.WPF.Excel.XLCellRange.#ctor(System.Int32,System.Int32,System.Int32,System.Int32,System.Int32,System.Int32,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.-ctor.html#C1_WPF_Excel_XLCellRange__ctor_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_">XLCellRange(int, int, int, int, int, int, XLReferenceType, XLReferenceType, XLReferenceType, XLReferenceType)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates an instance of an <a class="xref" href="C1.WPF.Excel.XLCellRange.html">XLCellRange</a> object containing a specified range.</p>
</td>
      </tr>
    </tbody>
  </table>
  <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_WPF_Excel_XLCellRange_Book" data-uid="C1.WPF.Excel.XLCellRange.Book">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Book.html#C1_WPF_Excel_XLCellRange_Book">Book</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a reference to the parent <a class="xref" href="C1.WPF.Excel.C1XLBook.html">C1XLBook</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ColumnCount" data-uid="C1.WPF.Excel.XLCellRange.ColumnCount">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ColumnCount.html#C1_WPF_Excel_XLCellRange_ColumnCount">ColumnCount</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of columns in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ColumnFrom" data-uid="C1.WPF.Excel.XLCellRange.ColumnFrom">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ColumnFrom.html#C1_WPF_Excel_XLCellRange_ColumnFrom">ColumnFrom</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the left column in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ColumnFromRef" data-uid="C1.WPF.Excel.XLCellRange.ColumnFromRef">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ColumnFromRef.html#C1_WPF_Excel_XLCellRange_ColumnFromRef">ColumnFromRef</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the reference type of the left column in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ColumnTo" data-uid="C1.WPF.Excel.XLCellRange.ColumnTo">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ColumnTo.html#C1_WPF_Excel_XLCellRange_ColumnTo">ColumnTo</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the index of the last column in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ColumnToRef" data-uid="C1.WPF.Excel.XLCellRange.ColumnToRef">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ColumnToRef.html#C1_WPF_Excel_XLCellRange_ColumnToRef">ColumnToRef</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the reference type of the right column in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_IsEmpty" data-uid="C1.WPF.Excel.XLCellRange.IsEmpty">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.IsEmpty.html#C1_WPF_Excel_XLCellRange_IsEmpty">IsEmpty</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the range is empty.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RangeType" data-uid="C1.WPF.Excel.XLCellRange.RangeType">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RangeType.html#C1_WPF_Excel_XLCellRange_RangeType">RangeType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a type (default, indirect or offset) for this cell range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RowCount" data-uid="C1.WPF.Excel.XLCellRange.RowCount">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RowCount.html#C1_WPF_Excel_XLCellRange_RowCount">RowCount</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of rows in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RowFrom" data-uid="C1.WPF.Excel.XLCellRange.RowFrom">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RowFrom.html#C1_WPF_Excel_XLCellRange_RowFrom">RowFrom</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the top row in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RowFromRef" data-uid="C1.WPF.Excel.XLCellRange.RowFromRef">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RowFromRef.html#C1_WPF_Excel_XLCellRange_RowFromRef">RowFromRef</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the reference type of the top row in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RowTo" data-uid="C1.WPF.Excel.XLCellRange.RowTo">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RowTo.html#C1_WPF_Excel_XLCellRange_RowTo">RowTo</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the index of the last row in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_RowToRef" data-uid="C1.WPF.Excel.XLCellRange.RowToRef">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.RowToRef.html#C1_WPF_Excel_XLCellRange_RowToRef">RowToRef</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the reference type of the bottom row in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_SheetCount" data-uid="C1.WPF.Excel.XLCellRange.SheetCount">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.SheetCount.html#C1_WPF_Excel_XLCellRange_SheetCount">SheetCount</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of sheets in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_SheetFrom" data-uid="C1.WPF.Excel.XLCellRange.SheetFrom">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.SheetFrom.html#C1_WPF_Excel_XLCellRange_SheetFrom">SheetFrom</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the first sheet in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_SheetTo" data-uid="C1.WPF.Excel.XLCellRange.SheetTo">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.SheetTo.html#C1_WPF_Excel_XLCellRange_SheetTo">SheetTo</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the index of the last sheet in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Sheets" data-uid="C1.WPF.Excel.XLCellRange.Sheets">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Sheets.html#C1_WPF_Excel_XLCellRange_Sheets">Sheets</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an array of <a class="xref" href="C1.WPF.Excel.XLSheet.html">XLSheet</a> objects.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Style" data-uid="C1.WPF.Excel.XLCellRange.Style">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Style.html#C1_WPF_Excel_XLCellRange_Style">Style</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <a class="xref" href="C1.WPF.Excel.XLStyle.html">XLStyle</a> object associated with this range of cells.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Value" data-uid="C1.WPF.Excel.XLCellRange.Value">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Value.html#C1_WPF_Excel_XLCellRange_Value">Value</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the complex value associated with this range of cells.</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_WPF_Excel_XLCellRange_Clone" data-uid="C1.WPF.Excel.XLCellRange.Clone">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Clone.html#C1_WPF_Excel_XLCellRange_Clone">Clone()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a copy of this cell range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Contains_C1_WPF_Excel_XLCellRange_" data-uid="C1.WPF.Excel.XLCellRange.Contains(C1.WPF.Excel.XLCellRange)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Contains.html#C1_WPF_Excel_XLCellRange_Contains_C1_WPF_Excel_XLCellRange_">Contains(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the range contains a specific range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Contains_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_" data-uid="C1.WPF.Excel.XLCellRange.Contains(C1.WPF.Excel.XLSheet,System.Int32,System.Int32)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Contains.html#C1_WPF_Excel_XLCellRange_Contains_C1_WPF_Excel_XLSheet_System_Int32_System_Int32_">Contains(XLSheet, int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the range contains a specific cell.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_Intersects_C1_WPF_Excel_XLCellRange_" data-uid="C1.WPF.Excel.XLCellRange.Intersects(C1.WPF.Excel.XLCellRange)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.Intersects.html#C1_WPF_Excel_XLCellRange_Intersects_C1_WPF_Excel_XLCellRange_">Intersects(XLCellRange)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the range intersects another range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ToA1_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_" data-uid="C1.WPF.Excel.XLCellRange.ToA1(System.Int32,System.Int32,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ToA1.html#C1_WPF_Excel_XLCellRange_ToA1_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_">ToA1(int, int, XLReferenceType, XLReferenceType)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets string with row and column reference in A1 mode.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ToR1C1_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_" data-uid="C1.WPF.Excel.XLCellRange.ToR1C1(System.Int32,System.Int32,C1.WPF.Excel.XLReferenceType,C1.WPF.Excel.XLReferenceType)">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ToR1C1.html#C1_WPF_Excel_XLCellRange_ToR1C1_System_Int32_System_Int32_C1_WPF_Excel_XLReferenceType_C1_WPF_Excel_XLReferenceType_">ToR1C1(int, int, XLReferenceType, XLReferenceType)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets string with row and column reference in R1C1 mode.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLCellRange_ToString" data-uid="C1.WPF.Excel.XLCellRange.ToString">
          <a class="xref" href="C1.WPF.Excel.XLCellRange.ToString.html#C1_WPF_Excel_XLCellRange_ToString">ToString()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a reference string that represents the range.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>