https://doc.djeeni.com/ 2026-07-09T19:46:14+00:00 https://doc.djeeni.com/ https://doc.djeeni.com/lib/tpl/djeeni/images/favicon.ico text/html 2021-05-06T21:53:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_add&rev=1620330810&do=diff WSheet Add Note: This process step is obsolete and will be removed from later versions of Djeeni. Use WSheet Use to create/add new worskeheets Worksheet add process step lets you add a new worksheet next to an already used worksheet on the fly in the same workbook, like shown on the picture below. text/html 2024-02-18T10:21:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_filteradd&rev=1708248112&do=diff WSheet Filter Add The Worksheet Filter Add process step allows you to filter the specified column of the specified worksheet. It works like the Excel data filter. You can filter by up to two criteria by adding them to the criteria fields and choosing the logical operator (And / Or). If you want to filter by only one value/expression, you should leave the optional text/html 2024-02-18T10:30:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_filterclear&rev=1708248634&do=diff WSheet Filter Clear This step clears all filters that are set on the specified worksheet. Parameters: * On worksheet: the Djeeni name of the worksheet where all the filters should be cleared. text/html 2024-02-18T11:43:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_normalise&rev=1708252987&do=diff Cleanse Date This step lets you standardize date formats from a source worksheet where dates are entered using different formats and Excel displays them as text or a number. text/html 2024-02-18T12:04:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_pdf&rev=1708254292&do=diff WSheet Create PDF To disseminate the results of a Djeeni process you can create a PDF version from any worksheet in use. Parameters * From worksheet: the Djeeni name of a worksheet in use * PDF filename: The name of the PDF file that should be created. The filename is not allowed to contain folder (gets the same folder as the worksheet) and extension (will be .PDF) part. text/html 2024-02-18T09:36:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_release&rev=1708245408&do=diff WSheet Release There can be cases (mostly within lists; but also to free computer memory) when you have to release a worksheet and want to reuse the given Djeeni name for another worksheet. In such cases you can explicitly release a worksheet in use. text/html 2024-02-18T09:29:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_rename&rev=1708244984&do=diff WSheet Rename This step is only applicable for target worksheets. You can rename used worksheets on the fly with the following parameters: * Worksheet: the Djeeni name of the worksheet to be renamed. * New Excel name: the new Excel name of the worksheet. Follow the MS Excel worksheet naming rules. text/html 2024-02-18T01:56:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://doc.djeeni.com/doku.php?id=en:process_steps:worksheet:wsheet_use&rev=1708217786&do=diff WSheet Use WSheet Use is the most frequent process step in Djeeni to tell that the process has something to do with a worksheet. It does much more than just 'open' an existing workbook with a specified worksheet in it: * Based on settings it can also create a new worksheet in an existing workbook; even further it can create a new workbook with the first worksheet;