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

Assign text to a cell in the current Excel worksheet.

 

The fomat cell is set as Text.

 

Syntax

 

CHGVAR                 VAR(&CMD) VALUE('XLSETTEXT')

CHGVAR                 VAR(&PARM1) VALUE('Coordinates')

CHGVAR                 VAR(&PARM2) VALUE('Text')

CALL                   PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1
                       &PARM2 &RESULT)

 

Parameters

 

Parameters

 

Parm1

 

 

 

 

 

 

 

 

 

 

Parm2


Coordinates of the cell to modify.

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

If Parm1 is not specified, the active cell will be modified.

 


Text to assign.

 

 

 

Examples

 

CHGVAR

VAR(&CMD) VALUE('XLSETTEXT')

CHGVAR

VAR(&PARM1) VALUE('$A$1')

CHGVAR

VAR(&PARM2) VALUE('Dépenses')

CALL

PGM(LNCCMD) PARM(&HANDLE &CMD &OPT &PARM1 +

&PARM2 &RESULT)

or

 LNCCMD CMD(XLSETTEXT) PARM1('C7') PARM2('Aura')

or

LNCCMD CMD(XLSETTEXT) PARM1('Name') PARM2('Aura')

or (modification of active cell)

LNCCMD CMD(XLSETTEXT) PARM2('Aura')

 

See also

 

• XLCELLNAME

• XLGETVALUE

• XLGOTOCELL

• XLSETVALUE