Description:
The variable generated during the process of loop.
Note:
c |
The cell where for statement is placed |
#c |
The sequence number of the loop |
Example:
|
A |
B |
C |
|
|
1 |
=demo.query("select * from EMPLOYEE") |
|
|
|
|
2 |
=[] |
|
|
|
|
3 |
for A1 |
|
|
Loop through A1’s table sequence, during which the current record is skipped if DEPT column value is "Sales", otherwise append the loop number of the current record to A2’s sequence as a value |
|
4 |
|
if A3.DEPT=="Sales" |
|
||
5 |
|
|
next |
||
6 |
|
>A2=A2|[#A3] |
|
|
|