worksheet_to_matrix
Convert scattered XYZ data from a worksheet into a gridded matrix, enabling 3D surface, contour, or heatmap visualization.
Instructions
Convert XYZ worksheet columns into a matrix by gridding (xyz2mat).
Enables 3D surface / contour / heatmap from scattered XYZ data.
Args: data_book: Source workbook name data_sheet: Source sheet name x_col: X column (1-based) y_col: Y column (1-based) z_col: Z column (1-based) rows: Output matrix rows (default 20) cols: Output matrix columns (default 20) matrix_book: Optional name for the output matrix book
Returns: Name of the created matrix
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data_book | Yes | ||
| data_sheet | Yes | ||
| x_col | Yes | ||
| y_col | Yes | ||
| z_col | Yes | ||
| rows | No | ||
| cols | No | ||
| matrix_book | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |