SetInputData2 [ClassedPostLayer]
SetInputData2 sets the classed post map input data file and columns and can be used to specify the DataFileOptions parameter.
The SetInputData2 command should be used instead of SetInputData 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.SetInputData2( DataFileName, xCol, yCol, zCol, LabCol, DataFileOptions )
|
Parameter |
Type |
Required/ Optional |
Default |
Description |
|
DataFileName |
String |
Required |
This provides the path and file name of the data file. |
|
|
xCol |
Long |
Optional |
1 (Column A) |
This provides the column containing X values. |
|
yCol |
Long |
Optional |
2 (Column B) |
This provides the column containing Y values. |
|
zCol |
Long |
Optional |
3 (Column C) |
This provides the column containing Z values. |
|
LabCol |
Long |
Optional |
4 (Column D) |
This provides the column containing symbol labels. |
|
DataFileOptions |
String |
Optional |
"" |
This specifies the data import options. |
Example
This example demonstrates how to specify a new sheet from an Excel file for an existing classed post map.
ClassedPostLayer.SetInputData2(DataFileName:=SurferApp.Path+"\Samples\Demogrid.xls", _
DataFileOptions:="sheet=sheet2", xCol:=1, yCol:=2, zCol:=3, LabCol:=4)
Used by: ClassedPostLayer Object