User Tools

Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:process_steps:range_cell:cellset [2020/03/12 13:32]
andraz
en:process_steps:range_cell:cellset [2024/02/24 14:11] (current)
tiger
Line 1: Line 1:
 +{{indexmenu_n>1}}
 ====== Cell Set ====== ====== Cell Set ======
  
-A value or formula can be set to a cell using this step with the following parameters:+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'   * **Cell**: Complete Djeeni cell reference with worksheet Djeeni name, column letter and number - for example: 'DjeeniName!D4'
   * **Value / formula**: MS Excel value or formula   * **Value / formula**: MS Excel value or formula
Line 7: Line 8:
 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. 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.
  
-{{djeeni:cell_set.png}}+{{ :en:process_steps:range_cell:cellset.png?nolink&800 |}}
  
-Note: The value that you can set can be specified using easy-to-use but powerful extended [[.en:concepts:djeeniformula|Djeeni formulas]].+Note: The value that you can set can be specified using easy-to-use but powerful extended [[:en:concepts:djeeniformula|Djeeni formulas]].