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)