Djeeni Documentation

User Tools

Site Tools

Trace:

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:concepts:djeeniname [2020/05/16 23:53]
tiger [Rules, best practice] 		en:concepts:djeeniname [2021/09/03 11:24] (current)
levi [Rules, best practice]
Line 1: Line 1:
 +{{indexmenu_n>1}}
 ====== Djeeni Names ====== ====== Djeeni Names ======
  
Line 5: Line 6:
   * 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. Once this location is specified in the **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** process step you can simply refer to this worksheet throughout your process by its Djeeni name. Using **WSheet Use** has one more advantage. If the location of the workbook or the Excel name of the worksheet is changed you only have to change **WSheet Use** to refer to the new location and/or worksheet name and your process is running again.+Please note that in Djeeni you work always with worksheets (and not workbooks). Every worksheet has a physical location in a workbook that can be found in some folder of the computer or network. Once this location is specified in the **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** process step you can simply refer to this worksheet throughout your process by its Djeeni name. Using **WSheet Use** has one more advantage. If the location of the workbook or the Excel name of the worksheet is changed you only have to change **WSheet Use** to refer to the new location and/or worksheet name and your process is running again.
  
 ===== Rules, best practice ===== ===== Rules, best practice =====
  
-Djeeni names can contain only letters (a-z, A-z), numbers (0-9), underscore (_), dash (-) and question mark (? - Useful for naming if sections). A Djeeni name **must** contain at least 5 characters. No space or other characters are allowed. To improve the readability of the process it is recommended to start all Djeeni names with 2 characters identifying the element named:+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   ^Example           ^ ^If you name a ^Start with   ^Example           ^
Line 20: Line 28:
 |Column List   |cl                   |clMonths         | |Column List   |cl                   |clMonths         |
  
-  +If you follow this recommendation please apply it both for the Djeeni name parameter in **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** and later when you refer to the worksheet in cell or range references.

Page Tools

en/concepts/djeeniname.1589666004.txt.gz · Last modified: 2020/05/16 23:53