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

  • 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 as displayed in Excel that 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. Target worksheets on the other hand can be modified in consecutive process steps
  • Update links in the workbook?: If links in the workbook must be updated before using it: Yes (default) / No
  • If Target then worksheet action: It can be decided what should happen if the worksheet already exists or does not yet exist. Possible settings:
    • If worksheet does exist then use it as is; If worksheet does not exist then stop with error: this option is useful when we want to add data to an existing worksheet
    • If worksheet does exist then use it as is; If worksheet does not exist then create it: 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 exist then delete and recreate it; If worksheet does not exist then create 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 exist then stop with Error; If worksheet does not exist then create it: this option avoids accidentally overwriting an existing worksheet
  • Workbook open password (Optional): Password for opening the containing workbook
  • Workbook write-reserved password (Optional): Password for writing the containing workbook