GET

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)