Writing a COL file for a worksheet

WKSCOL

This keyword allows you to associate a field name with a specific worksheet column. The syntax for a statement using this keyword is:

fieldname: WKSCOL columnletter

Where:

• fieldname is the name of the field in the view.
• columnletter is the letter of the source column in the worksheet that maps to that field name.

Only columns specified by the WKSCOL keyword will be imported.

RANGE

This keyword specifies the worksheet range to be imported. The syntax for a statement using this keyword is:

RANGE rangename

Where:

• rangename is the name of the range in the worksheet.

The range must be a valid range name in the imported file.

If you use a RANGE statement, the first WKSCOL statement in the COL file must refer to the first column in the range. For example, if the range starts at column D, the first WKSCOL statement in the COL file must be:

Fieldname: WKSCOL D

Note that a RANGE statement in a COL file overrides any range name entered in the Worksheet Import Settings box.