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().