Click or drag to resize

CellRange Methods

The CellRange type exposes the following members.

Methods
 NameDescription
Public methodCopyTo(String) Copies this cell range to another position in the same worksheet.
Public methodCopyTo(ExcelWorksheet, String) 
Public methodCopyTo(Int32, Int32) Copies this cell range to another position in the same worksheet.
Public methodCopyTo(ExcelWorksheet, Int32, Int32) Copies this cell range to another worksheet.
Public methodEquals Determines whether the specified CellRange is equal to the current CellRange.
(Overrides ObjectEquals(Object))
Public methodFindText Finds the first occurrence of the specified text in the current cell range.
Public methodGetEnumerator Returns an enumerator for the CellRange.
Public methodGetHashCode Returns the hash code of this object.
(Overrides ObjectGetHashCode)
Public methodGetReadEnumerator Returns enumerator for the CellRange.
Public methodGetSubrange(String, String) Returns new cell range using start and end position.
Public methodGetSubrange(Int32, Int32, Int32, Int32) Returns new cell range using absolute indexing.
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodOverlaps Checks if this cell range overlaps with another cell range.
Public methodStatic memberPositionToRowColumn Converts position string ("A1", "BN27", etc.) to row and column index.
Public methodStatic memberRowColumnToPosition Converts row and column index to position string ("A1", "BN27", etc.).
Public methodSetBorders Sets the color and style of the lines according to a specific set of borders in one or more Excel cells.
(Overrides ExcelRangeSetBorders(MultipleBorders, SKColor, LineStyle))
Public methodToString Returns a String that represents the current CellRange.
(Overrides ObjectToString)
Top
See Also