5.4.10 READ
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)
