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.

`trap 0`	Print error message and terminate program.
`trap 1`	Return scalar error code which can be checked for with `scalmiss()`.