Djeeni Documentation

User Tools

Site Tools

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:user_guide:worksheet_modify [2020/06/05 17:30]
tiger [Renaming a workbook] 		en:user_guide:worksheet_modify [2022/04/19 18:46] (current)
tiger [Modify Worksheets / Workbooks]
Line 1: Line 1:
 {{indexmenu_n>6}} {{indexmenu_n>6}}
-====== Modifying worksheets and workbooks ======+====== Modifying Worksheets/Workbooks ======
  
 Djeeni can perform the MS Excel workbook and worksheet manipulation operations. Djeeni can perform the MS Excel workbook and worksheet manipulation operations.
Line 6: Line 6:
 ===== Creating a new workbook ===== ===== Creating a new workbook =====
  
-Use the **Wbook New** process step (under the Workbook category on the [[en:user_interface:toolbar|Process Toolbar]]). Tips to fill out the parameters+Use the **[[en:process_steps:workbook:wbook_new|Wbook New]]** process step (under the Workbook category on the [[en:user_interface:toolbar|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 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.
Line 16: Line 16:
 ===== Renaming a workbook ===== ===== Renaming a workbook =====
  
-Djeeni can rename or move your workbook with the **WBook Rename** process step (under the Workbook category on the [[en:user_interface:toolbar|Process Toolbar]]). Tips to fill out the parameters:+Djeeni can rename or move your workbook with the **[[en:process_steps:workbook:wbook_rename|WBook Rename]]** process step (under the Workbook category on the [[en:user_interface:toolbar|Process Toolbar]]). Tips to fill out the parameters:
  
   * The workbook can be moved to another folder with this operation.   * The workbook can be moved to another folder with this operation.
Line 23: Line 23:
  
 ===== Adding a worksheet to a workbook ===== ===== Adding a worksheet to a workbook =====
 +
 +Djeeni can add a new worksheet next to an already used worksheet. Use the **[[en:process_steps:worksheet:wsheet_add|WSheet Add]]** process step (under category Worksheet on the [[en:user_interface:toolbar|Process Toolbar]]).
 ===== Renaming a worksheet ===== ===== Renaming a worksheet =====
 +
 +Djeeni can rename a worksheet in use. Use the **[[en:process_steps:worksheet:wsheet_rename|WSheet Rename]]** process step (under category Worksheet on the [[en:user_interface:toolbar|Process Toolbar]]).
 ===== Inserting rows/columns into a worksheet ===== ===== Inserting rows/columns into a worksheet =====
-===== Why there is no delete worksheet or workbook? ===== 
  
 +If it is needed to insert rows or columns onto a target worksheet then the **[[en:process_steps:range_cell:insertrowcolumn|Insert Row/Column]]** process step (under category Range / Cell on the [[en:user_interface:toolbar|Process Toolbar]]) comes handy. Djeeni intelligently recognizes if it is about inserting columns (letter) or rows (number).
 +===== Why there is no delete worksheet or delete workbook? =====
 +
 +Djeeni puts safety first. It protects source worksheets from being even modified and in general prevents any data loss. If there would be delete worksheet or delete workbook it would be accidentally used unintended. We really want to avoid that. So, we intentionally do not provide the option to delete anything.

Page Tools

en/user_guide/worksheet_modify.1591371032.txt.gz ยท Last modified: 2020/06/05 17:30