This is an old revision of the document!
See the older version of this step (before May 2021) below
WSheet Use is the most frequent process step in Djeeni to tell that the process has something to do with a worksheet. It does much more than just 'open' an existing workbook with a specified worksheet in it:
The WSheet Use process step has these parameters
The worksheet does exist and its workbook has a (possibly dynamic) location therefore the workbook path and the Excel name are known. Also it is known if the worksheet is used only as a data source or will also be modified (target). In case of the Target value is set then the Target action parameter can be set to Exists: use as is / Not Exists: Error.
WSheet Use is an acronym for worksheet use - in this process step the user can specify the worksheet and the workbook that will be used in the next steps of the process and define the parameters, such as writing permissions (declaring the worksheet either as a source or a target), updating links and passwords.
Every worksheet that is used during a process (either source or target) should be declared within Djeeni with the following parameters: