.

HCLSoftware Business Partner
Domino Consulting Services
CRUCIAL Notes Tools
+1 212-599-2048

Domino Consulting Services
CRUCIAL Notes Tools
Domino administration
Notes development

Facebook Twitter YouTube
Chat now       
.
ProductsDownloadsNewsAbout usContact


Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

APPLICATION DESIGN

Writing a COL file for a worksheet
To import worksheets using COL files, use these keywords:

WKSCOL

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


Where:
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:


Where:
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:


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

See Also