clear()

Read(1994) Label: clear cell value,

Description:

Clear the cell value.

Syntax:

clear a:b,c,d:e

Note:

The function clears values and #@ in certain cells. With only a: specified, it clears the cell values in a code block where a is the master cell.

Parameter:

a:b,c,d:e

The cells whose values need to be cleared.

Example:

 

A

 

1

=demo.query("select * from EMPLOYEE")

 

2

clear A1

Clear value of cell A1.

 

 

A

B

 

1

=demo.query("select * from EMPLOYEE")

=[]

 

2

>B1=A1.select(EID>6)

 

 

3

=[]

 

 

4

if A1.len()>10

 

 

5

 

>A3=A1.len()+10

 

6

clear A1:B2

 

Clear values of cells from A1to B2.

7

clear A4:

 

Clear cell values in a code block whereA4 is the master cell.