Range Set

The process step Range Set is the Djeeni counterpart of data entry on a worksheet. You can enter a value into a single cell or the same value into a range of cells:

  Range Set    Cell/Range=wsExample!A4:A5    Value=Age
  Range Set    Cell/Range=wsExample!B4    Value=54
  Range Set    Cell/Range=wsExample!B5    Value=52

You do not have to use double quotes to assign text values.

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

  Range Set    Cell/Range=wsExample!C2    Value= =[$wsExample!B2]+3

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.