Contents |
Expand...
Convert Worksheet to Matrix by expand for columns or rows
1. wexpand2m iw:=[Book1]Sheet1! expand:=2 order:=0;
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Input Worksheet | iw |
Input Worksheet | |
Specifies the worksheet to be converted. |
| Expand for Every Row/Col | expand |
Input int | |
Specifies the number of rows/columns comprising one matrix row/column. |
| Orientation | order |
Input int | |
Expanding order
|
| Output Matrix | om |
Output MatrixObject | |
Specifies the output matrix See the syntax here. |
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:
More information about worksheet to matrix conversion, please refer to the help of w2m X-Function.