Create and import spreadsheets¶
New spreadsheets can be created within the MIKE Workbench as well as be imported from files (e.g. Excel format files).
Create a new spreadsheet¶
Right-click the root node or a group node and select Add New Spreadsheet
The spreadsheet is created in the database and added as a sub-node to the active group.
When created the name of the sheet is editable allowing the default name to be changed.
Import a spreadsheet¶
Right-click the root node or a group node and select Add New Spreadsheet
A standard File Open dialog appears for selection of th file. Three standard formats are supported. Select the file and click Open.
Upon successful import the spreadsheet in the MIKE Workbench is named after the file and represented by an new node in the active group.
Rename a spreadsheet¶
Right-click the spreadsheet to rename and select Rename.
The text in the node becomes editable. Change the text and press Enter. To cancel editing press Esc.
After changing the name the node is placed alphabetically within the group.
Copy a spreadsheet¶
Right-click the spreadsheet and press Copy. Alternatively selected the node and press keys Ctrl+C.
This will put the spreadsheet into the clipboard.
Copy can be performed on multiple spreadsheets at a time as well as on a group or groups.
Right-click a group node and select Paste. Alternatively select the group and press keys Ctrl+V.
This will insert the spreadsheet in the clipboard into the selected group.
The option is only available if a spreadsheet is available in the clipboard.
If the group is new – or collapsed – the new spreadsheet node will be hidden. Click the plus-sign (+) next to the node to reveal the content of the group.
The group unfolds.
An automatic ally created unique name simply adds a counter to the original name.
Copying a group (or groups) is similar – only then the whole branch (or branches) is copied to the new location.
Move a spreadsheet¶
The moving of a spreadsheet between groups is carried out as a combination of Cut and Paste operation.
Right-click the spreadsheet and press Cut. Alternatively selected the node and press keys Ctrl+X.
This will put the spreadsheet into the clipboard.
Cut can be performed on multiple spreadsheets at a time.
The Cut-option is only available if all the selected spreadsheets are not open.
Right-click a group and select Paste. Alternatively select a group and press keys Ctrl+V.
This will insert the spreadsheet in the clipboard into the selected group.
The option is only available if a spreadsheet is available in the clipboard.
Note the spreadsheet that was cut is indicated with a dimmed grey font.
From here on the behavior is similar to that of the Copy Spreadsheet action.
Delete a spreadsheet¶
Select a group, multiple groups or multiple spreadsheets. Right-click and select Delete.
All the selected objects will be deleted from the database and removed from the explorer.
Only group(s) at same level can be selected together.
The delete operation must be confirmed via a pop-up dialog.