2.2.1.4 wexpand2m

Menu Information

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;

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 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:

Wexpand2m help English files image002.jpg

2. Expand convert by 2 columns:

Wexpand2m help English files image004.jpg

More information about worksheet to matrix conversion, please refer to the help of w2m X-Function.

Related X-Functions

m2w, w2m, r2m


Keywords:smooth