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:process_steps:wbooklist [2020/02/23 02:54]
tiger 		en:process_steps:wbooklist [2020/02/24 07:41] (current)
tiger
Line 1: Line 1:
 ====== Workbook lists ====== ====== Workbook lists ======
  
-Djeeni allows you to work with a set of workbooks by repeating steps for a worksheet of each workbook in the set. You should use **WBook List Start** and **WBook List Next** to create a loop:+Djeeni allows you to work with a set of workbooks by repeating steps for //a worksheet// of each workbook in the set. You should use **WBook List Start** and **WBook List Next** to create a loop:
  
 <code> <code>
Line 9: Line 9:
 </code> </code>
  
-All files in a workbook list are either source or target worksheets. You can nest workbook lists to use multiple source and target files at the same time:+All workbooks in a workbook list are either source or target workbooks. You can nest workbook lists to use multiple source and target workbooks at the same time:
  
 <code> <code>
-  WBook List Start <source worksheets>+  WBook List Start <source workbooks>
     ... Process steps for each source worksheet...     ... Process steps for each source worksheet...
-    WBook List Start <target files>+    WBook List Start <target workbooks>
       ...Process Steps repeated for each source-target worksheet pair...       ...Process Steps repeated for each source-target worksheet pair...
     WBook List Next     WBook List Next
Line 22: Line 22:
 Please note that if in the above example we have 3 source files and 2 target files then the steps in the inner workbook list are executed 6 times (source1-target1, source2-target1, source3-target1, source1-target2, source2-target2, source3-target2). Please note that if in the above example we have 3 source files and 2 target files then the steps in the inner workbook list are executed 6 times (source1-target1, source2-target1, source3-target1, source1-target2, source2-target2, source3-target2).
  
-The filenames in the file list can contain wildcard characters **?** (1 character in the filename of the workbook) and ***** (several characters in the filename of the workbook). The workbook list can contain several filenames separated by semicolons (;). Examples:+The filenames in a //source// file list can contain wildcard characters **?** (1 character in the filename of the workbook) and ***** (several characters in the filename of the workbook). The workbook list can contain several filenames separated by semicolons (**;**). Examples:
  
 <code> <code>
-  +  c:\reports\jan2020.xlsx                           'one file 
 +  c:\reports\jan201?.xlsx                           'all January reports 2010-2019 
 +  c:\inputs\*.xlsx                                  'all files from the inputs folder 
 +  c:\company1\report.xlsx; c:\company2\report.xlsx  'workbooks from different folders 
 +</code>

Page Tools

en/process_steps/wbooklist.1582422871.txt.gz · Last modified: 2020/02/23 02:54