Class CellRange
CellRange class
Encapsulates the object that represents a range of cells within a spreadsheet.
Constructors
Name | Description |
---|
CellRange() | Default Constructor. |
CellRange(string, string) | CellRange Constructor. |
CellRange(int, int, int, int) | CellRange Constructor. |
Properties
Name | Description |
---|
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
Name | Description |
---|
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