GET
From LANSA Integrator
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)