This is an old revision of the document!
Table of Contents
Modifying worksheets and 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.
- It is not compulsory to give a Djeeni name to the new workbook. If there is no name given then the workbook will not be accessible by the Djeeni process. But this is really OK if you want to create just a series of 'empty' workbooks based on a template.
- Workbooks will be created with one worksheet. This one worksheet can be a normal empty worksheet or can contain a template from another file.
- Djeeni can check if the workbook to be created already exists or not. Set the Workbook action parameter accordingly (see also Using Worksheets).