2.16.3.24 Details of TreeNodes in Import OPJ


Options

The Options tree specifies import mode and columns information for the impOPJ X-Function.

Syntax: Options.Treenode:=<value>

Example: Options.FirstMode:=1 // Import to the new columns

Treenode Label Type Default Description
FirstMode Import Mode int 0 Options include:
  • 0: Replace Existing Data
    The data that exists in the target window will be wiped out. And the new data will be imported into it.
  • 3: Start New Books
    Create a new book for the file that will be imported.
  • 4: Start New Sheets
    Create a new sheet for the file that will be imported.
  • 1: Start New Columns
    Add new columns to the target worksheet and import the data into the new columns.

Include

The Include branch of Options tree specifies columns information for the impOPJ X-Function.

Syntax: Options.Include.Treenode:=<value>

Example: Options.Include.comments:=0 // Import the columns without Comments column label.

Treenode Label Type Default Description
type Column Type int 1 Specify the Column Designations importing with the data.
lname Long Name int 1 Specify the columns Long Name importing with the data.
units Units int 1 Specify the columns Units importing with the data.
comments Commments int 1 Specify the columns Comments importing with the data.
params Parameters int 0 Specify the columns Parameter importing with the data.
udls User-Defined Labels int 0 Specify the columns User-Defined Labels importing with the data.