Djeeni Documentation en:process_steps

Communication

Anonymous (anonymous@undisclosed.example.com) — 2022-04-17T23:22:53+00:00

Communication There are four different process steps that allow communication about your processes and exchange of source or processed files with other users: * Message * E-mail Send * E-mail Download * Comment

Exit

Anonymous (anonymous@undisclosed.example.com) — 2022-04-17T23:32:50+00:00

Exit The default state of Djeeni is whenever we execute a process all the source worksheet will be closed and all the target worksheet will be opened for further editing. If we don’t wish to edit our worksheet after execution and we wish to save and close it we can do that by editing the exit step which only takes one parameter:

If - Else - End If

Anonymous (anonymous@undisclosed.example.com) — 2020-05-16T23:56:09+00:00

If - Else - End If The three process steps If, Else and End If together allow you to perform certain process steps if a condition is true (steps between If and Else) or false (between Else and End If): If ...Process steps if is true... Else ...Process steps if is false... End If

Integration

Anonymous (anonymous@undisclosed.example.com) — 2022-04-19T18:44:45+00:00

Integration The more data sources the Djeeni process can access the more it can automate. The following list is just the beginning. Send your request to reach out to another system to hello@djeeni.com . * SQL Connection * WSheet Import SQL * WSheet Link To PowerPoint

Working with Ranges / Cells

Anonymous (anonymous@undisclosed.example.com) — 2022-04-17T23:22:40+00:00

Working with Ranges / Cells You can work with cells and ranges on a worksheet in Djeeni much like you do it in MS Excel itself. To know for sure which cell or range is affected by a process step all cell and range references must be preceded by the

Row/Column lists

Anonymous (anonymous@undisclosed.example.com) — 2020-05-16T23:45:32+00:00

Row/Column lists Djeeni lets you process information from every row/column of a worksheet. Put your process steps between Row List Start and Row List Next/Column List Start and Column List Next: Row List Start ...Process steps for each row on the worksheet... Row List Next Column List Start ...Process steps for each column on the worksheet... Column List Next

en:process_steps:sidebar

Anonymous (anonymous@undisclosed.example.com) — 2020-06-03T16:46:44+00:00

en index

Process Steps

Anonymous (anonymous@undisclosed.example.com) — 2022-04-16T22:32:34+00:00

Process Steps In Djeeni you create automation processes that manipulate data from different source systems within MS Excel to deliver a target data set for further analysis / visualization. A Djeeni process is a series of process steps that: *

Workbook lists

Anonymous (anonymous@undisclosed.example.com) — 2020-02-24T07:41:50+00:00

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: WBook List Start ...Process Steps repeated for a worksheet in each workbook from ... WBook List Next

Working with Workbooks

Anonymous (anonymous@undisclosed.example.com) — 2022-04-17T23:22:03+00:00

Working with Workbooks Djeeni can execute the following workbook related process steps: * WBook New: Specify a workbook to be created during the process (and optionally use it further as target) * WBook Rename: Rename a workbook * Folder Create: Specify a new folder for workbooks to be created during the process

Working with Worksheets

Anonymous (anonymous@undisclosed.example.com) — 2024-02-18T00:47:01+00:00

Working with Worksheets Djeeni can execute the following worksheet related process steps: * WSheet Use: Specify a worksheet to be used in the process (either as a source or target data set) * WSheet Add: Add a worksheet next to another worksheet * WSheet Filter Add: Add a filter to a worksheet