TXlsCellRange Class
An Excel Cell range, 1-based.
Syntax
Namespace: FlexCel.Core
public class TXlsCellRange: ICloneable
Fields
Name | Description |
---|---|
Top | First row on range. |
Left | First column on range. |
Bottom | Last row on range. |
Right | Last column on range. |
Constructors
Name | Description |
---|---|
TXlsCellRange | Overloaded TXlsCellRange TXlsCellRange(String) TXlsCellRange(Int32, Int32, Int32, Int32) |
Methods
Name | Description |
---|---|
FullRange | Creates a range with all cells on the sheet (65536 rows x 256 columns in Excel 97-2003) |
Transpose | Returns the range transposed, rows by columns. |
Clone | Returns a copy of the original range. |
Offset | Creates a new range with the start at newTopRow, newLeftCol. |
HasRow | True if the specified row is in the range |
HasCol | True if the specified column is in the range |
CalcTopCell | Returns the minimum top and left coordinates for an array of ranges. If for example you have C7 and D5, this method will return C5 |
Dec | Returns a COPY of the range decremented by one. |
Inc | Returns a COPY of the range incremented by one. |
Equals | Returns true if both objects are equal. |
GetHashCode | Returns the hashcode of the object. |
Contains | Returns true if the cell is inside the range. |
ToString | A human-readable representation of the range. |
Operators
Name | Description |
---|---|
Equality | Returns true if both objects are equal. Note this is for backwards compatibility, this is a class and not immutable, so this method should return true if references are different. But that would break old code. |
Inequality | Returns true if both objects do not have the same value. Note this is for backwards compatibility, this is a class and not immutable, so this method should return true if references are different. But that would break old code. |