XLCLEAR

Purpose:

Clears ActiveX connection to Excel established by XLGET or XLPUT.

Syntax:

XLCLEAR(verbose)

verbose

-

Optional. An integer, display termination messages:

0:

do not display messages (default)

1:

display maeesages

Returns:

A 1 if a connection existed, else 0.

Example:

W1: rand(10, 3)

xlput("A1:C10", W1)

W2: xlget("A1:C10")

xlclear

 

W1 == W2 is all ones, that is W1 and W2 are equivalent. The data is retrieved from the current Sheet of the current Workbook. The Excel connection is terminated.

Remarks:

If Excel is visible, XLCLEAR does not terminate Excel, though the variables used by DADiSP are still cleared.

 

See XLINIT to open a specific Excel Worksheet file.

See Also:

XLINIT

XLGET

XLPUT

XLSAVE

XLSAVEAS