2.2.1.12 XYZ2Mat

Contents

Menu Information

Worksheet: Convert to Matrix: XYZ Gridding

Brief Information

Convert XYZ data to matrix

Command Line Usage

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

2. XYZ2Mat -r 2 iz:=[Book1]Sheet1!((A"x position",B"y position",C:F)) settings.ConvertToMatrix:=2;

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 iz

Input

XYZRange

<active>
 XYZ worksheet data which needs to convert into matrix by gridding. If multiple Z columns are specified, each Z column will be converted to a matrix object of the same matrix sheet.
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

MatrixLayer

<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. And if input range contains multiple sets of Z columns, virtual matrix is not supported.

See the syntax of Output Notations.

Examples

  1. Create a new workbook and import the data <Origin Installation Directory>\Samples\Matrix Conversion and Gridding\XYZ Random Gaussian.dat into this workbook.
  2. Highlight column C and select Set As: Z from the right-click menu to set column C as Z column.
  3. 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.
  4. 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.
    Xyz2mat example dialog.png
  5. Click the OK button to get the result as below.
    Xyz2mat example result.png

Description

This X-Function convert XYZ worksheet data into matrix by XYZ Gridding. For more information, please refer to our User Guide: Description of XYZ Gridding Methods.

More Information

settings (Gridding Settings)

The settings (Gridding Settings) tree specifies the XYZ gridding settings.

Syntax: settings.Treenode:=<value>

Example: settings.ConvertToMatrix:=2


Treenode Type Default Description
ExamData
(Data Examination) 		XStepTol (Tolerance for Even X Step) doule 1E-8 ExamData (Data Examination)
YStepTol (Tolerancce for Even Y Step) double 1E-8
XPrecision (Tolerance for Duplicate X) double 1E-8
YPrecision (Tolerance for Duplicate Y) double 1E-8
RemoveDuplicate (Replace Duplicate With) int 0
ConvertToMatrix
(Gridding Method and Parameters) 		columns (Columns) int 20 Gridding Method and Parameters
rows (Rows) int 20
QILF (Quadratic Interpolant Locality Factor) double 18
WFLF (Weight Function Locality Factor) double 9
searchradiu (Search Radius) doule 2
averadius double 2
minipoints (Minimum Points) double 10
maxipoints (Maximum Points) double 100
CorrelationSmoothing (Smoothing) int 1
TPSSmoothing (Smoothing) int 0
extrapolation (Extrapolation) int 0
outsizevalue (Outside Value) int 0
tolerance (Tolerance) double 0.005
advanced
(Advanced) 		SelectRange (Range Restriction) treenode Advanced
  • xmin (X Minimum): 0
  • xmax (X Maximum): 0
  • ymin (Y Minimum): 0
  • ymax (Y Maximum): 0
noextrapolation
(No Extrapolation outside Boundary) 		int 0 No Extrapolation outside Boundary
previewplottype
(Preview Plot Type) 		int 1 Preview Plot Type

Algorithm

References

Related X-Functions

w2m, m2w, r2m, wexpand2m, xyz_regular, xyz_sparse, xyz_shep, xyz_shep_nag, xyz_renka, xyz_renka_nag, xyz_tps

Keywords:worksheet, gridding