AddVariogram2
AddVariogram2 adds a new variogram plot and can be used to specify the DataFileOptions parameter. Returns a Variogram object.
The AddVariogram2 command should be used instead of AddVariogram when the worksheet being loaded is an Excel file where the sheet name needs to be specified. It can also be used to specify any data import options when loading a data file.
Syntax
object. AddVariogram2( DataFileName, xCol, yCol, zCol, ExclusionFilter, DupMethod, xDupTol, yDupTol, NumAngularDivisions, NumRadialDivisions, DetrendMethod, ShowReport, MaxLagDistance, DataFileOptions )
|
Parameter |
Type |
Default |
Description |
|
DataFileName |
String |
required; This provides the path and file name of the data file. |
|
|
xCol |
Long |
optional; This provides the X data column |
|
|
yCol |
Long |
|
optional; This provides the Y data column |
|
zCol |
Long |
|
optional; This provides the, Z data column |
|
ExclusionFilter |
String |
"" |
optional; This provides the data exclusion filter. This is used to set up rules for excluding data when gridding. |
|
DupMethod |
srfDupAll |
optional; This provides the method of eliminating duplicate data points. Duplicate data are two or more data points having nearly identical X, Y coordinates. |
|
|
xDupTol |
Double |
0.0 |
optional; This provides the X Tolerance , i.e., the X spacing of points in order to be considered a duplicate. |
|
yDupTol |
Double |
0.0 |
optional; This provides the Y Tolerance , i.e., the Y spacing of points in order to be considered a duplicate |
|
NumAngularDivisions |
Integer |
180 |
optional; This provides the number of angular divisions in the variogram grid. |
|
NumRadialDivisions |
Integer |
100 |
optional; This provides the number of radial divisions in the variogram grid. |
|
DetrendMethod |
srfDetrendNone |
optional; This provides the method of detrending the data. |
|
|
ShowReport |
Boolean |
False |
optional; This parameter sets whether the variogram report should be shown or not. You need to set it to True, to generate the report. |
|
MaxLagDistance |
Variant |
|
optional; This provides the maximum lag distance (separation) of variogram pairs. |
|
DataFileOptions |
String |
"" |
optional; This parameter is used to specify the data import options |
Example 1
This example demonstrates creating a variogram plot from an Excel sheet.
'Creates a variogram from the sheet in the Excel workbook
Set Variogram = Doc.Shapes.AddVariogram2(DataFileName:="c:\temp\book1.xlsx", _
DataFileOptions:="sheet=sheet2")
Example 2
This script displays all the methods and properties in the Shapes collection.
Used by: Shapes collection