PreviousNext
Help > Programming with LAUNCHER Office > LNCCMD commands > Commands list > XLSETVALUE command
XLSETVALUE command

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


Coordinates of the cell to modify.

The coordinates of the cell can be given in the form:
- Syntax $B$3. Example: $B$3 is column B, line 3.
- Syntax CL. C to designate the column and L to designate the line. Example: B3 designates line 3, and column 2 (B).
- Symbolic name given to a cell or group of cells.

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

 

XLCELLNAME

XLGETVALUE

XLGOTOCELL

XLSETTEXT

XLCELLS