Differences
This shows you the differences between two versions of the page.
| Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
en:concepts:wbooklist [2020/12/13 16:40]
tiger |
en:concepts:wbooklist [2021/04/26 23:00] (current)
tiger |
| | {{indexmenu_n>3}} |
| ====== Workbook lists ====== | ====== Workbook lists ====== |
| |
| Data processing frequently involves working with a set (or list) of workbooks containing worksheets with the same data structure that should be consolidated (if they are data sources) or should be created (in case of target data). Djeeni has the powerful **WBook List Start** and **WBook List Next** process steps that can process multiple workbooks in a loop. | Data processing frequently involves working with a set (or list) of workbooks, each containing a worksheet with the same data structure that should be consolidated (if they are data sources) or should be created (in case of target data). Djeeni has the powerful **WBook List Start** and **WBook List Next** process steps that can process multiple workbooks in a loop. |
| |
| With **WBook List Start** you instruct Djeeni to take the workbooks in its list one by one and select a worksheet form the current workbook. Further process steps will work with this selected worksheet up to **WBook List Next**. At this point Djeeni takes the next workbook, select the specified worksheet out of it and repeats the process steps up to **WBook List Next**: | At **WBook List Start** you instruct Djeeni to take the workbooks in its list one by one and select a worksheet from the current workbook. Further process steps will work with this selected worksheet up to **WBook List Next**. At this point Djeeni takes the next workbook, select the specified worksheet out of it and repeats the process steps up to **WBook List Next**: |
| |
| <code> | <code> |
