====== Import parameters from Excel ======
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 an loaded in the editing and run mode, not in the online mode.
===== Out and In =====
Assign global paramters to your macro
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_11_46.png?1200|}}
When you store your parameters, you have to store the macro above you parameters, otherwise the parameters will not be stored
===== Create Parameter =====
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_27.png?400|}}
You can directly edit this parameters in iCon-L or you save this attributes.
===== Store Parameter=====
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_42.png?400|}}
===== Excel work =====
When you open the stored "CSV" file in excel you can combine your data with the stored sheet.
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_16_43.png?1200|}}
===== Load Parameter =====
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_11_25.png?400|}}
After you combined your data and stored the file you can load the "CSV" file into iCon-L. Be sure, that you decide for the correct macro to load the data for.
===== Result =====
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_33.png?1200|}}
As the result, you see the datas from your excel sheet in iCon-L.
===== Combine Vectors to a Matrix =====
If you want to have a matrix output instead of an vector output, you must combine the input parameters into a matrix.
{{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_25_30.png?1200|}}
===== Tutorial Video =====
{{http://www.youtube.com/v/ra6CGAfjfiI?.swf?400×333}}