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 Properties
 Comment | Gets or sets comment |
| EndPosition | Gets name of the last (bottom-right) cell in this cell range. |
| FirstColumnIndex | Gets index of the first (leftmost) column. |
| FirstRowIndex | Gets index of the first (topmost) row. |
| Formula | Gets or sets formula string. |
| Height | Gets height of this cell range, in rows. |
| IndexingMode | Gets indexing mode used for cell range. |
| IsAnyCellMerged | Returns true is any cell in this cell range is merged; otherwise, false. |
| IsStyleDefault | Returns true if all cells in cell range or merged range have default cell style; otherwise, false. |
| Item | Overloaded. Gets excel cell with the specified name or at the specified position. |
| LastColumnIndex | Gets index of the last (rightmost) column. |
| LastRowIndex | Gets index of the last (bottommost) row. |
| Merged | Gets or sets whether cells in this range are merged. |
| StartPosition | Gets name of the first (top-left) cell in this cell range. |
| Style | Gets or sets cell style (CellStyle) on one or more excel cells. |
| Value | Gets or sets cell value on one or more excel cells. |
| Width | Gets width of this cell range, in columns. |
Public Instance Methods
| CopyTo | Overloaded. Copies this cell range to the specified position. |
| Equals | Determines whether the specified CellRange is equal to the current CellRange. |
| ExportToHtml | Overloaded. Exports all data from the range to a new file or XmlTextWriter in HTML format. |
| 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