Class CellRange

CellRange class

Encapsulates the object that represents a range of cells within a spreadsheet.

public class CellRange

Constructors

NameDescription
CellRange()Default Constructor.
CellRange(string, string)CellRange Constructor.
CellRange(int, int, int, int)CellRange Constructor.

Properties

NameDescription
Address { get; }Gets the address of CellRange object.
Columns { get; }Gets total columns of CellRange object.
EndColumn { get; set; }Gets or sets the index of the end column of the range.
EndRow { get; set; }Gets or sets the index of the end row of the range.
Rows { get; }Gets total rows of CellRange object.
StartColumn { get; set; }Gets or sets the index of the start column of the range.
StartRow { get; set; }Gets or sets the index of the start row of the range.
Worksheet { get; }Gets worksheet object.

Methods

NameDescription
AutoFill(CellRange, GridAutoFillType)Automaticall fill the target range.
Copy(CellRange)Copies from another CellRange object.
getName()get the name defined for the cellrange.if no name defined for this cellrange ,just return null
Inside(CellRange)check whether current CellRange is inside in the target CellRange
override ToString()Returns a String that represents the current CellRange.

See Also