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