Worksheet: Convert to Matrix: Expand...
Convert worksheet to matrix by expanding rows or columns
wexpand2m iw:=[Book1]Sheet1! expand:=2 order:=0;
Please refer to the page for additional option switches when accessing the x-function from script
| 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.
Keywords:smooth