Import parameters from Excel
Tutorial video (English subtitles)
If you want to use parameters from an excel sheet in iCon-L you have to follow this instruction.
The parameters can only be saved and loaded in editing and run mode, not in online mode.
Inputs and outputs
Assign global parameters to your macro
When storing parameters, the macro has to be saved above the parameters, otherwise the parameters will not be saved.
Right-click on the input of the macro block and select "Assign Global Parameter".
Create Parameters
You can directly edit the parameters in the program or you can save the attributes and edit them in Excel.
To edit the parameters, add vectors and values in the dialog.
Save Parameters
In Excel
When you open the saved „CSV“ file in excel you can implement your data in the saved worksheet.
Load Parameter
After you combined your data and stored the file you can load the „CSV“ file into iCon-L. Make sure to select the correct macro to load the data for.
Result
As the result, you see the data from your excel sheet in iCon-L.
Combine Vectors to a Matrix
If you want to have a matrix output instead of a vector output, you must combine the input parameters into a matrix.
