5.4.11 WRITE

The WRITE command is used to write a range of cells from a working list to a nominated worksheet.

All rows and columns from the working list are written out to the specified sheet using the R1C1 start position. Any fields specified in the EXCLUDE keyword are not included in the write operation.

Syntax:

Command

Keyword

Value

Developer notes

WRITE

SHEET

value

Optional. A specific sheet name can be entered otherwise the current context sheet is used.

R1C1

n,n

Optional. The starting row and column defaults to 1, 1. This indicates the starting position for rows and columns from the working list to be written out to the specified sheet.

EXCLUDE

field,field

An optional comma-separated list of working list fields. These fields will be excluded from the write operation.

 

Example

WRITE #WRKLST(field,field)

 

WRITE SHEET(Sales) #WRKLST(field,field)

 

WRITE R1C1(10,5) #WRKLST(field,field)

 

WRITE R1C1(10,5) EXCLUDE(field) #WRKLST(field,field)