TXlsCellRange Class
An Excel Cell range, 1-based.
Syntax
Namespace: FlexCel.Core
public class TXlsCellRange: ICloneableFields
| 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. |