xlsMakeRange¶
Purpose¶
Builds an Excel® range string from a row/column pair.
Format¶
-
range =
xlsMakeRange
(row, col)¶ - Parameters
row (scalar or 2x1 vector) – row(s)
col (scalar or 2x1 vector) – column(s)
- Returns
range (string) – an Excel®-formatted range specifier.
Examples¶
Example 1: Create a single cell index¶
// Scalar inputs
r = 3;
c = 6;
range = xlsMakeRange(r, c);
print range;
produces:
F3
Example 2: Create a cell range string¶
// 2x1 vector inputs
r = { 2, 37 };
c = { 3, 19 };
range = xlsMakeRange(r, c);
print range;
produces:
C2:S37
Remarks¶
If row is a 2x1 vector, it is interpreted as follows
\(row[1]\) |
starting row |
\(row[2]\) |
ending row |
If col is a 2x1 vector, it is interpreted as follows:
\(col[1]\) |
starting column |
\(col[2]\) |
ending column |
If xlsMakeRange()
fails, it will either terminate and print an error
message or return a scalar error code, which can be decoded with
scalerr, depending on the state of the trap flag.
|
Print error message and terminate program. |
|
Return scalar error code which can be checked for
with |
See also
Functions xlsGetSheetCount()
, xlsGetSheetSize()
, xlsGetSheetTypes()