XLFIND command

Search for a value in the active sheet.

The first cell that contains the required value, is activated.

Syntax

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

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

CHGVAR VAR(&PARM2)VALUE(' ')

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

&PARM1 &PARM2 &RESULT)

Parameters

Parm1

The value to look for in the sheet.

RESULT

If the value is found, the value TRUE is returned. Otherwise, it is FALSE.

The result passes through the return message from the PC (variable &RESULT).

Example

DCL VAR(&RESULT) TYPE(*CHAR) LEN(512)

LNCOPEN

LNCCMD CMD(EXCELOPEN)

LNCCMD CMD(XLOPENFILE) PARM1('C:\A\temp.xlsx')

LNCCMD CMD(EXCELSHOW)

LNCCMDR CMD(XLFIND) PARM1('Aura') RESULT(&RESULT)

LNCCMD CMD(NOP) PARM1(&RESULT)

See also

• XLREPLACE