GET
The GET command is used to get information about the current open Excel document.
The GET command must be preceded by an OPEN command with read mode.
Required
GET -------- OBJECT ----------- *SHEETS ----------------------->
*ROWCOUNT
Optional
>-- SHEET ------------ sheet1 ------------------------|
value
Keywords
|
OBJECT |
The type of object to return must be indicated as either *SHEETS or *ROWCOUNT. A value of *SHEETS returns a working list with all the sheet names in the current document. A value of *ROWCOUNT returns the number of rows in the worksheet specified by the SHEET keyword in the JSM message field. |
|
SHEET |
This keyword is used in combination with the value OBJECT(*ROWCOUNT) to indicate which sheet the row count should be returned for. A specific sheet name can be entered otherwise the default value of sheet1 will be used. |
Examples
The following examples use the GET command to retrieve information about the current Excel document.
RDML
USE BUILTIN(JSM_COMMAND) WITH_ARGS('GET OBJECT(*SHEETS) SERVICE_LIST(SHEET)') TO_GET(#JSMSTS #JSMMSG #WRKLST)
RDMLX
use builtin(jsmx_command) with_args(#jsmhandle 'get object(*rowcount) sheet(parts)') to_get(#jsmsts #jsmmsg)