2.2.1.2 r2m

1 Brief Information
2 Command Line Usage
3 X-Function Execution Options
4 Variables
5 Description
6 Examples
7 Related X-Functions

Brief Information

Convert range of worksheet cells to matrix

Command Line Usage

1. r2m irng:=[Book1]Sheet1!Col(1)[1]:Col(4)[5]

2. r2m irng:=[Book1]Sheet1!Col(1)[1]:Col(4)[5] om:=[MBook1]MSheet1!Mat(1)

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Input

irng

Input

Range

Specifies input data range

Output Matrix

Output

MatrixObject

<new>

Specifies output matrix

See the syntax here.

Description

This function converts a range of worksheet data into matrix directly, and assigns the matrix coordinates automatically. More information about worksheet to matrix conversion, please refer to the help of w2m X-Function.

Examples

Run from the Command window

1. Import the file \Samples\Matrix Conversion and Gridding\DirectXY.dat.

2. Type the following script in command window: r2m irng:=!Col(1)[1]:Col(4)[5];

After you executed the script, the appointed range of worksheet data was converted into matrix directly.

Code Sample

/*
This example shows how convert worksheet range data into matrix.
The sample data is exe_path\Samples\Matrix Conversion and Gridding\DirectXY.dat.
1. Load data to a new created workbook.
2. Convert worksheet range into matrix.
*/
// Get sample file name
fn$ = system.path.program$ + "Samples\Matrix Conversion and Gridding\DirectXY.dat";
// New a workbook
newbook;
// Import data to active worksheet
impASC fn$;

// Convert worksheet range into matrix
r2m irng:=!Col(2)[2]:Col(5)[6];