Assign a value to a cell in the current Excel worksheet.
Syntax
CHGVAR |
VAR(&CMD) VALUE('XLSETVALUE') |
CHGVAR |
VAR(&PARM1) VALUE('Coordinates'] ') |
CHGVAR |
VAR(&PARM2) VALUE('Value') |
CALL |
PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 + &PARM2 &RESULT) |
Parameters
Parameters |
|
Parm1 |
The coordinates of the cell can be given in
the form: If the coordinates of the cell are not filled in, the active cell will be modified.
|
Parm2 |
Value to be assigned.
|
Example
CHGVAR VAR(&CMD) VALUE('XLSETVALUE')
CHGVAR VAR(&PARM1) VALUE('Sum')
CHGVAR VAR(&PARM2) VALUE('1000')
CALL PGM(LNCCMD) PARM(&HANDLE &CMD &OPT +
&PARM1 &PARM2 &RESULT)
See also
• XLCELLS