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.