GemBox.Spreadsheet

CellRange Methods

The methods of the CellRange class are listed below. For a complete list of CellRange class members, see the CellRange Members topic.

Public Static Methods

PositionToRowColumn Converts position string ("A1", "BN27", etc.) to row and column index.
RowColumnToPosition Converts row and column index to position string ("A1", "BN27", etc.).

Public Instance Methods

CopyToOverloaded. 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.

See Also

CellRange Class | GemBox.Spreadsheet Namespace