5 5 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.
	IGNORE	*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)