Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:process_steps:rowlist [2020/02/23 03:29] tiger |
en:process_steps:rowlist [2020/05/16 23:45] tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Row lists ====== | + | ====== Row/ |
| - | 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/ |
| < | < | ||
| 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 | ||
| </ | </ | ||
| - | 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/ |
| < | < | ||
| [$wsCompanies!C# | [$wsCompanies!C# | ||
| - | < | + | </code> |
| 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: | ||
| + | |||
| + | < | ||
| + | Row List Start djeeniName: | ||
| + | [$wsName!C# | ||
| + | Column List Start djeeniName: | ||
| + | [$wsName!# | ||
| + | [$wsName!C# | ||
| + | [# | ||
| + | Column List Next | ||
| + | Row List Next | ||
| + | </ | ||
| + | |||
| + | NB: column references behave as numbers in contexts (e.g. calculations, | ||