TXlsCellRange Record
An Excel Cell range, 1-based.
Syntax
Unit: FlexCel.Core
TXlsCellRange = record;
Fields
Name | Description |
---|---|
HasValue | False if the record doesn't have a defined value. When this field is false, the values of left, right, top and bottom don't matter. |
Top | First row on range. |
Left | First column on range. |
Bottom | Last row on range. |
Right | Last column on range. |
Methods
Name | Description |
---|---|
Intersects | Returns true if this range intersects with another. |
Create | Overloaded Create Create(string) Create(Integer, Integer, Integer, Integer) |
Null | Creates an invalid Cell range with the IsNull field set. |
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. |
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. |
IsNull | Returns true if the record doesn't have a defined value. This is the inverse of HasValue |
Operators
Name | Description |
---|---|
Equality | Adapts the = operator so it returns true when both instances have the same values. |
Inequality | Adapts the <> operator so it returns true when both instances have different values. |