https://doc.djeeni.com/ 2026-10-10T01:49:51+00:00 https://doc.djeeni.com/ https://doc.djeeni.com/lib/tpl/djeeni/images/favicon.ico text/html 2021-01-21T12:51:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:activate&rev=1611229885&do=diff Download and Activate Djeeni Follow this video or these instructions: * Get your Djeeni app here. After that, you are automatically directed to the download page. * Click on the Download Djeeni button. Djeeni is downloaded to your computer in the form of an MS Excel Workbook. text/html 2022-04-19T18:46:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:cellrange_basic&rev=1650386817&do=diff Working with Data in Cells/Ranges In the previous section, we have learned how to identify worksheets. The next step is to access data on a worksheet. Accessing cells and ranges In MS Excel a cell (let it be C5) on a worksheet is accessed by specifying the containing workbook and worksheet followed by the column letter and row number: text/html 2022-10-25T14:22:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:djeeniformula&rev=1666700536&do=diff Using Djeeni Formulas In the end, MS Excel data sit in the cells within worksheets. In this chapter, you can learn in detail how to * access the data of a source cell; * process/calculate it to be used as a result value in a target location (i.e., a cell on a target worksheet); text/html 2020-06-16T22:53:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:examples&rev=1592340833&do=diff How to? / Examples Below you can find all examples of the user guide. Click on the links to get to the relevant page that explains the example. * How to refer to a worksheet * Hot to access/refer to a cell * How to lookup a cell containing a given value * How to fill a whole range with a fix value * How to find the last row with data in a column * How to find the last column with data in a row * How to combine MS Excel functions with Djeeni formulas * Process skeleton of a cons… text/html 2022-10-25T14:10:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:excelfunction&rev=1666699843&do=diff Excel functions in Djeeni processes Djeeni is created for people who have built up experience and proficiency in MS Excel by using it regularly for different data processing tasks. We do want you to be able to keep and utilize your proficiency and therefore built Djeeni to seamlessly work together with MS Excel and its powerful built-in functions. In the sections below we explain through practical examples how and for what purpose you can embed Excel functions at different Djeeni process steps. text/html 2023-08-04T22:21:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:first_process&rev=1691180471&do=diff The First Process Any Djeeni process consists of a series of different process steps. You can think of a process step as a Lego building block - simple and easy to use. Nevertheless, the possible combinations of the steps are endless giving you the power to automate very complex processes. text/html 2020-06-03T17:43:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:sidebar&rev=1591199013&do=diff en index text/html 2022-04-16T22:31:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:start&rev=1650141068&do=diff User Guide In this section, we guide you through Djeeni. You can learn step by step all concepts and functions accompanied by simple yet powerful examples. Choose the topics in the left index column. text/html 2022-04-19T18:49:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:tips&rev=1650386971&do=diff The Djeeni Best Practice Djeeni is a set of building blocks. You have a lot of freedom in how you build your Djeeni process combining these blocks. Nevertheless, we have designed Djeeni having an optimal combination of MS Excel + Djeeni process steps in mind to achieve maximum efficiency with minimum effort. Please consider using the below tips. text/html 2021-01-22T12:51:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:worksheet_basic&rev=1611316263&do=diff Accessing Worksheets The data structure of MS Excel is quite simple: * Data i.e., number, text, date values are in cells * Cells are organised in rows, columns or ranges * A worksheet contains the cells and ranges * Worksheets may be grouped into one workbook or they can be found in different workbooks. text/html 2021-01-10T14:44:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:worksheet_lists&rev=1610286251&do=diff Working With Many Worksheets Naming and using a worksheet is a very useful concept in case of a few, known worksheets. There are cases, though, when several or many worksheets with the same structure must be batch processed or created. Typical cases are consolidation or splitting tasks. text/html 2022-04-19T18:46:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:user_guide:worksheet_modify&rev=1650386772&do=diff Modifying Worksheets/Workbooks Djeeni can perform the MS Excel workbook and worksheet manipulation operations. Creating a new workbook Use the Wbook New process step (under the Workbook category on the Process Toolbar). Tips to fill out the parameters * It is not necessary to type the physical location of the workbook. Double click on the WBook New name in column A and use the Browse button in the popup window to select the containing folder.