https://doc.djeeni.com/ 2026-07-10T03:20:33+00:00 https://doc.djeeni.com/ https://doc.djeeni.com/lib/tpl/djeeni/images/favicon.ico text/html 2024-02-24T14:11:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:cellset&rev=1708780269&do=diff 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' text/html 2024-02-24T23:38:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:columnreorder&rev=1708814297&do=diff Column Reorder The process step Column Reorder does exactly what its name says. It solves a common problem when the source data has a different structure than the target data. In this simple step you can reorder the columns avoiding long and tedious copying and pasting column-by-column. text/html 2024-02-24T21:56:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:insertrowcolumn&rev=1708808163&do=diff Insert Row / Column This step is only applicable for target worksheets. Insert Row / Column process step comes in handy when you have to insert one or more rows or columns into an existing data set. The parameters you have to set are pretty straightforward: text/html 2024-02-24T18:04:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:locatevalue&rev=1708794268&do=diff Cell Lookup This step is used when you have a certain value and you are interested in which cell in a specified range that value is saved. There are three parameters that you have to specify: * Cell Djeeni name: Djeeni name with the absolute address of the cell where the value that you were searching for was found. You can refer to the found cell, column or row number later in other steps by using '|cell', '|column' or '|row' additions. text/html 2024-02-24T14:43:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:rangecopymove&rev=1708782200&do=diff Range Copy/Move To The basic process step to move data from one location to another is Range Copy/Move To. It works exactly the same as its manual version in Excel. You should first define ('select') the source range and then specify the top-left cell of the target range: text/html 2024-02-24T14:17:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:rangeset&rev=1708780637&do=diff Range Set This step is only applicable for target worksheets. The process step Range Set (together with Cell Set) is the Djeeni counterpart of data entry on a worksheet. You can multiply a single value to a range of cells (you do not have to use double quotes to assign text values): text/html 2024-02-24T21:31:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:rangeuse&rev=1708806715&do=diff Range Use The process step Range Use behaves like the named ranges in Excel. Once you assign a Djeeni name to your range you can use it in further process steps: Ranges can be named on worksheets that are already in use. text/html 2024-02-24T23:40:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:range_cell:timestamp&rev=1708814434&do=diff Timestamp This step is only applicable for target worksheets. Timestamp is a very simple process step, that requires only one parameter - the cell where you want to insert it. At the execution of the step the time and date of the execution are saved in the specified cell.