This is an old revision of the document!


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 Djeeni name of the containing worksheet:

  wsInput!D4
  wsReport!A2:B6

Djeeni provides you with these process steps:

  • Cell Set: Set a value to a cell or a range
  • Range Set: Set a value to a cell or a range
  • Range Use: Define a named range to be used in further process steps
  • Range Copy/Move: Copy or move a range to another location
  • Column Reorder: Reorder the columns of a worksheet in one step
  • Timestamp: Set the value of a cell to the current timestamp