str_to_range (MathScript RT Module Function)
Owning Class: string
Requires: MathScript RT Module
Syntax
c = str_to_range(a)
Legacy Name: str2rng
Description
Converts a spreadsheet range to matrix coordinates.
Inputs
| Name | Description |
|---|---|
| a | Specifies a Microsoft Excel spreadsheet range. a is a string. |
Outputs
| Name | Description |
|---|---|
| c | Returns four elements that describe a. The first and second elements in c represent the matrix row and column, respectively, of the top-left element of the spreadsheet range. The third and fourth elements in c represent the matrix row and column, respectively, of the bottom-right element of the spreadsheet range. c is a vector. |
Examples
A = 'A1..B3'
C = str_to_range(A)