The READ command is used to read a range of cells from the nominated worksheet into a working list. Each cell value has trailing blanks trimmed.

Syntax:

Command

Keyword

Value

Developer notes

READ

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 reading.

ROWCOUNT

integer

Conditional. Specify the number of rows to read. If no ROWCOUNT keyword is used all rows to the end of the sheet are read.

ROW

integer

Optional. Can be used instead of R1C1 and ROWCOUNT.
Only the specified row number is read, all the columns in the row are returned as entries in a single field working list.

IGNORE

*NONE

The default value of *NONE indicates that all entries should be processed.

*EMPTY

*EMPTY indicates that empty entries should be ignored.
An empty entry is where all cell values that make a list entry have an empty string value.

SCALE

integer

Optional. Specifies the decimal scale that will be used on numeric cells that have a general number format.
The default value is 4.

NUMBERFORMAT


Optional. See NUMBERFORMAT.

Example

    READ ROW(10) #WRKLST(field)

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

    READ R1C1(10,5) ROWCOUNT(4) #WRKLST(field,field,field)

    READ R1C1(10,5) SHEET(Sales) #WRKLST(field,field,field)

  • No labels