The methods of the CellRange class are listed below. For a complete list of CellRange class members, see the CellRange Members topic.
![]() PositionToRowColumn | Converts position string ("A1", "BN27", etc.) to row and column index. |
![]() RowColumnToPosition | Converts row and column index to position string ("A1", "BN27", etc.). |
CopyTo | Overloaded. Copies this cell range to the specified position. |
Equals | Determines whether the specified CellRange is equal to the current CellRange. |
FindText | Finds the first occurrence of the specified text in the current cell range. |
GetEnumerator | Returns an enumerator for the CellRange (all cells). |
GetHashCode | Returns the hash code of this object. |
GetReadEnumerator | Returns enumerator for the CellRange (only allocated cells). |
GetSubrange | Returns new cell range using start and end position. |
GetSubrangeAbsolute | Returns new cell range using absolute indexing. |
GetSubrangeRelative | Returns new cell range using relative indexing. |
Overlaps | Checks if this cell range overlaps with another cell range. |
SetBorders | Sets borders on one or more excel cells, taking cell position into account. |
ToString | Returns a String that represents the current CellRange. |
CellRange Class | GemBox.Spreadsheet Namespace