2.2.1.2 r2m

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)

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input irng

Input

Range

<active>

Specifies input data range

Output Matrix om

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];

Related X-Functions

m2v, w2m, wexpand2m


Keywords:direct, xyz, expand, gridding