====== 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}}