{{indexmenu_n>2}}
====== Working with Ranges / Cells  ======

You can work with cells and ranges on a worksheet in Djeeni much like you do it in MS Excel itself. To know for sure which cell or range is affected by a process step all cell and range references must be preceded by the [[en:concepts:djeeniname|Djeeni name]] of the containing worksheet:

<code>
  wsInput!D4
  wsReport!A2:B6
</code>

Djeeni provides you with these range/cell related process steps:  
  * [[.range_cell:locatevalue|Cell Lookup]]: Find the first cell in a range with a specified value
  * [[.range_cell:cellset|Cell Set]]: Set a value to a cell
  * [[.range_cell:rangeset|Range Set]]: Set a value to every cell in a range
  * [[.range_cell:rangeuse|Range Use]]: Define a named range to be used in further process steps
  * [[.range_cell:rangecopymove|Range Copy/Move]]: Copy or move a range to another location
  * [[.range_cell:columnreorder|Column Reorder]]: Reorder the columns of a worksheet in one step
  * [[.range_cell:timestamp|Timestamp]]: Set the value of a cell to the current timestamp
  * [[.range_cell:insertrowcolumn|Insert Row / Column]]: Insert rows/columns into an existing data set