TXlsCellRange Record

An Excel Cell range, 1-based.

Syntax

TXlsCellRange = record;

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.

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

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.

Name	Description
IsOneCell	Returns true if the range has only one cell.
RowCount	Number of rows on the range.
ColCount	Number of columns on the range.
CellRef	Gets or sets the string that defines the 2D-range in A1 notation.