WRITE
The WRITE command is used to write a range of cells from a working list into the nominated worksheet on the currently open document.
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.
The WRITE command must be preceded by an OPEN command with write mode.
WRITE ---------- SHEET ------------ sheet1 -------------------->
value
>-- R1C1 ------------- 1,1 ------------------------>
n,n
>-- EXCLUDE ---------- field,field ---------------->
>-- NUMBERFORMAT ---- *NONE -----------------------|
*DEFAULT
*CLIENT
*USERAGENT
value
Keywords
|
SHEET |
The name of the sheet working list value will be written to. If a sheet value is not specified the default sheet1 is applied. |
|
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. |
|
NUMBERFORMAT |
This optional keyword handles numeric strings where the decimal separator is not the decimal point character ".". Refer to NUMBERFORMAT for more information. |
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)