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
Input
Worksheet
Specifies the worksheet to be converted.
int
Specifies the number of rows/columns comprising one matrix row/column.
Expanding order Option list:
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.
m2w, w2m, r2m
Keywords:smooth