# 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) 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$$ starting row $$row$$ ending row

If col is a 2x1 vector, it is interpreted as follows:

 $$col$$ starting column $$col$$ 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().
{"ft_lang_label":"__label__en","ft_lang_prob":0.508672,"math_prob":0.97947943,"size":1171,"snap":"2020-45-2020-50","text_gpt3_token_len":354,"char_repetition_ratio":0.119108826,"word_repetition_ratio":0.082474224,"special_character_ratio":0.29632792,"punctuation_ratio":0.15137614,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99011475,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-11-28T10:28:30Z\",\"WARC-Record-ID\":\"<urn:uuid:e7192f7a-8e9f-4e0f-90cd-a15cfdb606e3>\",\"Content-Length\":\"16832\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:a61429ac-81fe-411b-9772-cf6f2c1bbefe>\",\"WARC-Concurrent-To\":\"<urn:uuid:ee0502d1-29fb-4ee4-ba12-20b31d44338c>\",\"WARC-IP-Address\":\"104.27.179.233\",\"WARC-Target-URI\":\"https://docs.aptech.com/gauss/xlsmakerange.html\",\"WARC-Payload-Digest\":\"sha1:7AHD4ZMJORKPITBMFD5STHIRXIKTJ55Y\",\"WARC-Block-Digest\":\"sha1:ZDTY5EZQACKZI5RUZ4WH3KALVSUAYXZI\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-50/CC-MAIN-2020-50_segments_1606141195417.37_warc_CC-MAIN-20201128095617-20201128125617-00033.warc.gz\"}"}