SetInputData2 [PostLayer]

SetInputData2 sets the 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, LabCol, SymCol, AngleCol, 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.
LabCol	Long	Optional	3 (Column C)	This provides the column containing symbol labels.
SymCol	Long	Optional	4 (Column D)	This provides the column containing symbol numbers.
AngleCol	Long	Optional	5 (Column E)	This provides the column containing symbol angles.
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 post map.

PostLayer.SetInputData2(DataFileName:=SurferApp.Path+"\Samples\Demogrid.xls", _

DataFileOptions:="sheet=sheet2", xCol:=1, yCol:=2, LabCol:=3, SymCol:=3)

Used by: PostLayer Object