This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
en:concepts:djeeniname [2020/02/23 12:56] tiger created |
en:concepts:djeeniname [2021/09/03 11:24] (current) levi [Rules, best practice] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{indexmenu_n> | ||
====== Djeeni Names ====== | ====== Djeeni Names ====== | ||
- | In Djeeni you work with worksheets, ranges, cells, lists of worksheets from workbooks, lists of rows on worksheets. Just like Excel, Djeeni allows you to name all of them. Actually, naming your worksheets, lists and if sections is compulsory. as names make your process much more logical and readable. It is much easier to say: | + | In Djeeni you work with worksheets, ranges, cells, lists of worksheets from workbooks, lists of rows/ |
* copy the **Summary** section of the **ERP Report** worksheet to the **Bottom line** section of the **Consolidation** worksheet; than | * copy the **Summary** section of the **ERP Report** worksheet to the **Bottom line** section of the **Consolidation** worksheet; than | ||
- | * copy **range D234:D245** on **\\server\finance\analysis\erp_exports\report202001.xlsx** workbook **Sheet1** worksheet to **range starting from B25** on **\\server\finance\consolidations\year2020\consolidation202001.xlsx** workbook **ERP data** worksheet | + | * copy **range D234:D245** on **%%\\server\finance\analysis\erp_exports\report202001.xlsx%%** workbook **Sheet1** worksheet to **range starting from B25** on **%%\\server\finance\consolidations\year2020\consolidation202001.xlsx%%** workbook **ERP data** worksheet |
- | Please note that in Djeeni you work always with worksheets. Every worksheet has a physical location in a workbook that can be found in some folder of the computer or network | + | Please note that in Djeeni you work always with worksheets |
+ | |||
+ | ===== Rules, best practice ===== | ||
+ | |||
+ | Djeeni names | ||
+ | |||
+ | * can contain letters (a-z, A-Z), numbers (0-9), underscore (_), dash (-) and question mark (? - Useful for naming if sections); | ||
+ | * must contain at least 5 characters; | ||
+ | * no space or other characters are allowed; | ||
+ | * must identify each and every object uniquely i.e., not just two worksheets but also a worksheet and a range must have different Djeeni names. This rule applies also within a workbook, row or column list. For example, it is not allowed to use **WSheet Use** inside a workbook list without **WSheet Release** in the same workbook list to give space for the next worksheet in the loop with the same Djeeni name. | ||
+ | |||
+ | To improve the readability of the process it is recommended (but not compulsory) to start all Djeeni names with 2 characters identifying the element named: | ||
+ | |||
+ | ^If you name a ^Start with | ||
+ | |Worksheet | ||
+ | |Range | ||
+ | |Cell |ce | ||
+ | |Condition | ||
+ | |WBook List |wl | ||
+ | |Row List | ||
+ | |Column List | ||
+ | |||
+ | If you follow this recommendation please apply it both for the Djeeni name parameter in **[[en: |