Cell Set

This step is only applicable for target worksheets. A value or formula can be set to a cell using this step with the following parameters:

  • Cell: Complete Djeeni cell reference with worksheet Djeeni name, column letter and number - for example: 'DjeeniName!D4'
  • Value / formula: MS Excel value or formula

Example: During the processing of the input data a new column called “Quarter” should be created on the worksheet ‘wsSalesData’. We can create the header of the column by setting cell F1 to “Quarter” value.

Note: The value that you can set can be specified using easy-to-use but powerful extended Djeeni formulas.