WSheet Use []

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 defining writing permissions (declaring the worksheet either as a source or a target).

Every worksheet that is used during a process (either source or target) should be declared within Djeeni with the following parameters:

• Worksheet Djeeni name: this name identifies the worksheet during the process
• Workbook folder: The physical location of the workbook to be used
• Workbook name (without filetype/extension): the name of the workbook file
• Workbook filetype/extension: the extension, identifying the version of an excel document (either .xls or .xlsx)
• Worksheet Excel name: name of the worksheet you would like to use
• Use worksheet as: here you can either choose Source or Target (default). Source worksheets are not allowed to be modified so Djeeni protects your data sources from accidentally being overwritten.
• If links in the workbook must be updated before using it: Yes (default) / No
• Action (only for target worksheets): It can be decided what should happen if the worksheet already exists or does not exist yet. Possible settings:
  • If worksheet does not exist then stop with error; If worksheet does exist then use it as is: this option is useful when we want to add data to an existing worksheet
  • If worksheet does not exist then create it; If worksheet does exist then use it as is: this option is useful when we want to create a worksheet and then add data to it (e.g. start a new worksheet every month and then add daily data to it)
  • If worksheet does not exist then create it; If worksheet does exist then delete and recreate it: this option is useful when we want to create the worksheet always from scratch (e.g. if the source is modified after an error is discovered in it then everything should be reprocessed again)
  • If worksheet does not exist then create it; If worksheet does exist then stop with Error: this option avoids accidentally overwriting an existing worksheet
• (Optional) Password for opening the containing workbook
• (Optional) Password for writing the containing workbook