Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:process_steps:rowlist [2020/02/23 03:29]
tiger
en:process_steps:rowlist [2020/05/16 23:45] (current)
tiger
Line 1: Line 1:
-====== Row lists ======+====== Row/​Column ​lists ======
  
-Djeeni lets you process information from every row of a worksheet. Put your process steps between **Row List Start** and **Row List Next**:+Djeeni lets you process information from every row/​column ​of a worksheet. Put your process steps between **Row List Start** and **Row List Next**/​**Column List Start** and **Column ​List Next**:
  
 <​code>​ <​code>​
Line 7: Line 7:
     ...Process steps for each row on the worksheet...     ...Process steps for each row on the worksheet...
   Row List Next   Row List Next
 +  ​
 +  Column List Start
 +    ...Process steps for each column on the worksheet...
 +  Column List Next  ​
 </​code>​ </​code>​
  
-If you want to refer to a cell of the current row inside the row list you can use #. For example, if you have a list of departments and column C contains the names of the departments then:+If you want to refer to a cell of the current row/​column ​inside the row/​column ​list you can use #. For example, if you have a list of departments and column C contains the names of the departments then:
  
 <​code>​ <​code>​
Line 16: Line 20:
  
 is the department name in the current row of the row list. is the department name in the current row of the row list.
 +
 +In case you nest several row/column lists then you should qualify the current row/column reference by the Djeeni Name of that list:
 +
 +<​code>​
 +  Row List Start djeeniName:​Outer
 +    [$wsName!C#​] ​                              '#​ refers to the row list Outer
 +    Column List Start djeeniName:​Inner
 +      [$wsName!#​4] ​                            '#​ refers to the column list Inner
 +      [$wsName!C#​] ​                            '#​ still refers (and valid!) to Inner
 +      [#​wsName!C[#​|Outer]] ​                    '#​ with qualifier refers to Outer
 +    Column List Next
 +  Row List Next
 +</​code>​
 +
 +NB: column references behave as numbers in contexts (e.g. calculations,​ row numbers) where the column letter would be invalid