CellRange Class

Represents an object of a rectangular group of worksheet cells.

Inheritance Hierarchy

SystemObject
SautinSoft.ExcelExcelRange
SautinSoft.ExcelCellRange

Namespace: SautinSoft.Excel
Assembly: SautinSoft.Excel (in SautinSoft.Excel.dll) Version: 2025.2.6

Syntax

Copy

public class CellRange : ExcelRange, IEnumerable

Public Class CellRange
	Inherits ExcelRange
	Implements IEnumerable

The CellRange type exposes the following members.

Properties

	Name	Description
	Comment	Gets or sets comment. (Overrides ExcelRangeComment)
	EndPosition	Gets name of the last cell in this cell range.
	FirstColumnIndex	Gets index of the first column.
	FirstRowIndex	Gets index of the first row.
	Formula	Gets or sets formula string. (Overrides ExcelRangeFormula)
	Height	Gets the height of this range of cells in rows.
	IsStyleDefault	Returns true if all cells in cell range or merged range have default cell style; otherwise, false. (Overrides ExcelRangeIsStyleDefault)
	ItemString	Gets excel cell with the specified full or partial name.
	ItemInt32, Int32	Gets excel cell at the specified relative position.
	LastColumnIndex	Gets index of the last column.
	LastRowIndex	Gets index of the last row.
	Merged	Gets or sets whether cells in this range are merged.
	StartPosition	Gets name of the first cell in this cell range.
	Style	Gets or sets cell style on one or more excel cells. (Overrides ExcelRangeStyle)
	Value	Gets or sets the value of a single cell or range of cells. (Overrides ExcelRangeValue)
	Width	Gets the width of this range of cells in columns.

Top

Methods

	Name	Description
	CopyTo(String)	Copies this cell range to another position in the same worksheet.
	CopyTo(ExcelWorksheet, String)
	CopyTo(Int32, Int32)	Copies this cell range to another position in the same worksheet.
	CopyTo(ExcelWorksheet, Int32, Int32)	Copies this cell range to another worksheet.
	Equals	Determines whether the specified CellRange is equal to the current CellRange. (Overrides ObjectEquals(Object))
	FindText	Finds the first occurrence of the specified text in the current cell range.
	GetEnumerator	Returns an enumerator for the CellRange.
	GetHashCode	Returns the hash code of this object. (Overrides ObjectGetHashCode)
	GetReadEnumerator	Returns enumerator for the CellRange.
	GetSubrange(String, String)	Returns new cell range using start and end position.
	GetSubrange(Int32, Int32, Int32, Int32)	Returns new cell range using absolute indexing.
	GetType	Gets the Type of the current instance. (Inherited from Object)
	Overlaps	Checks if this cell range overlaps with another cell range.
	PositionToRowColumn	Converts position string ("A1", "BN27", etc.) to row and column index.
	RowColumnToPosition	Converts row and column index to position string ("A1", "BN27", etc.).
	SetBorders	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))
	ToString	Returns a String that represents the current CellRange. (Overrides ObjectToString)

Top

Remarks

Cell range is determined by its top (FirstRowIndex), left (FirstColumnIndex), bottom (LastRowIndex) and right (LastColumnIndex) borders. This properties are read-only, so if you require different cell range use one of GetSubrange methods GetSubrangeRelative or GetSubrange). Cells in the range can be merged / unmerged by the use of Merged property.

Reference

SautinSoft.Excel Namespace