User Tools

Site Tools

Range Set

This step is only applicable for target worksheets. The process step Range Set (together with Cell Set) is the Djeeni counterpart of data entry on a worksheet. You can multiply a single value to a range of cells (you do not have to use double quotes to assign text values):

A value or formula can be set to a range with the following parameters:

  • Range: Complete Djeeni range reference with worksheet Djeeni name, column letter and number
  • Value / formula: MS Excel value or formula

Just like in Excel you can also assign formulas to cells by starting your value with “=”:

Please note that Djeeni considers the best practice to create your worksheet template first with formulas and then use Djeeni for filling it with data. Setting formulas in a Djeeni process is most of the time unnecessary.