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: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>

Page Tools

en/process_steps/wbooklist.1582423184.txt.gz · Last modified: 2020/02/23 02:59