User Tools

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
Next revision
Previous revision
en:process_steps:wbooklist [2020/02/23 02:59]
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 25: Line 25:
  
 <code> <code>
-  c:\reports\jan2020.xlsx                              'one file +  c:\reports\jan2020.xlsx                           'one file 
-  c:\reports\jan201?.xlsx                               'all January reports between 2010-2019 +  c:\reports\jan201?.xlsx                           'all January reports 2010-2019 
-  c:\inputs\*.xlsx                                     'all files from the inputs folder +  c:\inputs\*.xlsx                                  'all files from the inputs folder 
-  c:\company1\report.xlsx; c:\company2\report.xlsx     'workbooks from different maps+  c:\company1\report.xlsx; c:\company2\report.xlsx  'workbooks from different folders
 </code> </code>