Ecolego Wiki

User Tools

Site Tools

Trace:
exporting_parameters_to_excel

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
Last revision Both sides next revision
exporting_parameters_to_excel [2023/04/07 12:20]
daria [Selecting parameters] 		exporting_parameters_to_excel [2023/04/10 09:44]
daria [Properties]
Line 22: Line 22:
 By clicking on **Toggle** button additional window will be presented. This window presents information about selected block.  By clicking on **Toggle** button additional window will be presented. This window presents information about selected block. 
  
-{:toogle_export_excel.png.png}|Toggle window}+{{:toogle_export_excel.png|Toggle window}}
  
 ==== Setting up the Excel workbook ==== ==== Setting up the Excel workbook ====
Line 32: Line 32:
 ==== Selecting parameters ==== ==== Selecting parameters ====
  
-{{:exportmodel.png|Selecting parameters}}+ 
 +{{screenshots:export_model.png|Selecting parameters}}
  
 The list to the left of the window displays all [[Parameter|parameters]] and [[Lookup_table|lookup tables]] of the current project. Below the list a field allows you to search for [[Block|blocks]] with a specific name. By clicking the **More** button, more search options are shown. The list to the left of the window displays all [[Parameter|parameters]] and [[Lookup_table|lookup tables]] of the current project. Below the list a field allows you to search for [[Block|blocks]] with a specific name. By clicking the **More** button, more search options are shown.
Line 50: Line 51:
   * **GUID**. The [[excel_parameter_format|GUID]] represents a strong link between the value and your model, and will remain even if the parameter is moved or renamed in the model.   * **GUID**. The [[excel_parameter_format|GUID]] represents a strong link between the value and your model, and will remain even if the parameter is moved or renamed in the model.
  
-* **ID** - Export block with ID (//Sub-system name.Name of block//).+  * **ID** - Export block with ID (//Sub-system name.Name of block//).
  
-* **Type** -  Add column with type of block exported to Excel. +  * **Type** -  Add column with type of block exported to Excel. 
  
-* **Tags** - Add a tag for each of the blocks.+  * **Tags** - Add a tag for each of the blocks.
  
 ==== Export options ==== ==== Export options ====
Line 70: Line 71:
  
 Click the **…** button to open properties tab.  Click the **…** button to open properties tab. 
-This tab contains list of additional properties for all types of blocks may be exported. For eacg block type specific properties are presented and may be selected for export. +This tab contains list of additional properties for all types of blocks may be exported. For each block type specific properties are presented and may be selected for export. 
  
  
 ===== Finalizing the export ===== ===== Finalizing the export =====
 +
 +Click the **…** button  at thw **Select file** window to select a name and location for the Excel file.To save the file with a MS Excel Office 97 format, use the extension .xls. To save the file with a Office 2003-2010 format, use the extension .xlsx.
 +
  
 Once you have selected a name and location for the Excel file click **Export** button the button to finalize the export and close the window. Once you have selected a name and location for the Excel file click **Export** button the button to finalize the export and close the window.
exporting_parameters_to_excel.txt · Last modified: 2023/04/10 09:46 by daria

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki