CellRange MembersGemBox.Spreadsheet Help

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(Int32, Int32)
Copies this cell range to another position in the same worksheet.
Public methodCopyTo(ExcelWorksheet, String)
Copies this cell range to another 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 Object Equals(Object).)
Public methodFindText
Finds the first occurrence of the specified text in the current cell range.
Public methodGetEnumerator
Returns an enumerator for the CellRange (all cells).
Public methodGetHashCode
Returns the hash code of this object.
(Overrides Object GetHashCode .)
Public methodGetReadEnumerator
Returns enumerator for the CellRange (only allocated cells).
Public methodGetSubrange
Returns new cell range using start and end position.
Public methodGetSubrangeAbsolute
Returns new cell range using absolute indexing.
Public methodGetSubrangeRelative
Returns new cell range using relative indexing.
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 borders on one or more excel cells, taking cell position into account.
(Overrides AbstractRange SetBorders(MultipleBorders, Color, LineStyle).)
Public methodSort( SortDescription )
Sorts the rows of this CellRange by comparing values of ExcelCells in columns specified by sortDescriptions.
Public methodSort(IEnumerable SortDescription )
Sorts the rows of this CellRange by comparing values of ExcelCells in columns specified by sortDescriptions.
Public methodToString
Returns a String that represents the current CellRange.
(Overrides Object ToString .)
Back to Top
Properties
  NameDescription
Public propertyComment
Gets or sets comment
(Overrides AbstractRange Comment.)
Public propertyEndPosition
Gets name of the last (bottom-right) cell in this cell range.
Public propertyFirstColumnIndex
Gets index of the first (leftmost) column.
Public propertyFirstRowIndex
Gets index of the first (topmost) row.
Public propertyFormula
Gets or sets formula string.
(Overrides AbstractRange Formula.)
Public propertyHeight
Gets height of this cell range, in rows.
Public propertyIndexingMode
Gets indexing mode used for cell range.
Public propertyIsAnyCellMerged
Returns   is any cell in this cell range is merged; otherwise,  .
Public propertyIsStyleDefault
Returns   if all cells in cell range or merged range have default cell style; otherwise,  .
(Overrides AbstractRange IsStyleDefault.)
Public propertyItem Int32 
Gets excel cell at the specified index.
Public propertyItem String 
Gets excel cell with the specified full or partial name.
Public propertyItem Int32, Int32 
Gets excel cell at the specified relative position.
Public propertyLastColumnIndex
Gets index of the last (rightmost) column.
Public propertyLastRowIndex
Gets index of the last (bottommost) row.
Public propertyMerged
Gets or sets whether cells in this range are merged.
Public propertyStartPosition
Gets name of the first (top-left) cell in this cell range.
Public propertyStyle
Gets or sets cell style (CellStyle) on one or more excel cells.
(Overrides AbstractRange Style.)
Public propertyValue
Gets or sets cell value on one or more excel cells.
(Overrides AbstractRange Value.)
Public propertyWidth
Gets width of this cell range, in columns.
Back to Top
Explicit Interface Implementations
  NameDescription
Explicit interface implemetationPrivate methodIEnumerable GetEnumerator
Returns an enumerator for the CellRange (all cells).
Back to Top
See Also
CellRange Class
GemBox.Spreadsheet Namespace