2.2.1.4 wexpand2m

Worksheet: Convert to Matrix: Expand...

Brief Information

Convert worksheet to matrix by expanding rows or columns

Command Line Usage

 

wexpand2m iw:=[Book1]Sheet1! expand:=2 order:=0; 

Variables

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

Input

Worksheet

<active>

Specifies the worksheet to be converted.

Expand for Every Row/Col expand

Input

int

1

Specifies the number of rows/columns comprising one matrix row/column.

Orientation order

Input

int

row

Expanding order
Option list:

• Row:Row'
Expand in row
• Col:Column
Expand in column
Output Matrix om

Output

MatrixObject

<new>

Specifies the output matrix

See the syntax here.

Description

Some screen editors used to create ASCII files may have an upper limit for the number of characters allowed on a single line or column. This upper limit may even be less than the number of columns/rows needed in the matrix. To compensate for this, one row/column of matrix data can be stored in multiple rows/columns of an ASCII file. When converting this kind of data into matrix, this function copies your worksheet data from the number of ASCII file rows/columns into the first row/column of the matrix, repeating this procedure until all ASCII file rows/columns have been converted. For example:

1. Expand convert by 2 rows:

2. Expand convert by 2 columns: