2.2.1.12 XYZ2Mat

Menu Information

Worksheet: Convert to Matrix: XYZ Gridding

Convert XYZ data to matrix

XYZ2Mat iz:=(col(a),col(b),col(c)) settings.ConvertToMatrix:=1 om:=<new: Sparse>;

Display Name	Variable Name	I/O and Type	Default Value	Description
Input	iz	Input XYZRange	<active>	XYZ worksheet data which needs to convert into matrix by gridding.
Gridding Settings	settings	Input TreeNode	<unassigned>	Settings for gridding XYZ worksheet data. Please refer to More Information section below for more details.
Output Matrix	om	Output MatrixObject	<new>	If this check-box is selected, it allows specifying a matrix for the output gridding data. Output Matrix and Output Virtual Matrix can only one be selected. See the syntax of Output Notations.
Output Virtual Matrix	ovm	Output Worksheet	<new>	If this check-box is selected, it allows specifying a worksheet for the output gridding data. And the output worksheet is arranged as a virtual matrix. Output Matrix and Output Virtual Matrix can only one be selected. See the syntax of Output Notations.

Create a new workbook and import the data <Origin Installation Directory>\Samples\Matrix Conversion and Gridding\XYZ Random Gaussian.dat into this workbook.
Highlight column C and select Set As: Z from the right-click menu to set column C as Z column.
Keep column C highlighted and select main menu Worksheet: Convert to Matrix: XYZ Gridding or run XYZ2Mat -d; in the Command Window to open the XYZ Gridding dialog.
Expand the Gridding Settings branch, choose Random (Renka Cline) from the Gridding Method and Parameters drop-down list, and 3D Color Map Surface from the Preview Plot Type drop-down list. Check the Preview check-box to the left of the OK button. In the Preview panel, select the Preview Result tab to show the result in 3D color map surface graph.
Click the OK button to get the result as below.