WRITE
The WRITE command is used to write a range of cells from a working list to a nominated worksheet.
All rows and columns from the working list are written out to the specified sheet using the R1C1 start position. Any fields specified in the EXCLUDE keyword are not included in the write operation.
Required
WRITE
Optional
>-- SHEET ----------- value ---------------------->
>-- R1C1 ------------ n,n ------------------------>
>-- EXCLUDE --------- field,field ----------------|
Keywords
|
SHEET |
A specific sheet name can be entered otherwise the current context sheet is used. |
|
R1C1 |
The starting row and column defaults to 1, 1. This indicates the starting position for rows and columns from the working list to be written out to the specified sheet. |
|
EXCLUDE |
An optional comma-separated list of working list fields. These fields will be excluded from the write operation. |
Examples
RDML
USE BUILTIN(JSM_COMMAND) WITH_ARGS('WRITE SHEET(PARTS) R1C1(10,3) SERVICE_LIST(LINENUM,PARTNUM,PARTDSC,PARTAMT,PARTQTY)') TO_GET(#JSMSTS #JSMMSG #ORDLIST)
RDMLX
use builtin(jsmx_command) with_args(#jsmhandle 'write sheet(parts) r1r1(10,3)') to_get(#jsmsts #jsmmsg #ordlist)