Differences
This shows you the differences between two versions of the page.
|
public:user_s_documents:icon-l:programming_issues:excel_parameter [2014/02/16 14:50] genzmehr [Result] |
public:user_s_documents:icon-l:programming_issues:excel_parameter [2014/02/27 09:47] (current) genzmehr [Combine Vectors to a Matrix] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Import parameters from Excel ====== | ====== Import parameters from Excel ====== | ||
| If you want to use parameters from an excel sheet in iCon-L you have to follow this instruction. | If you want to use parameters from an excel sheet in iCon-L you have to follow this instruction. | ||
| + | <note important>The parameters can only be saved an loaded in the editing and run mode, not in the online mode.</note> | ||
| ===== Out and In ===== | ===== Out and In ===== | ||
| Assign global paramters to your macro | Assign global paramters to your macro | ||
| Line 6: | Line 7: | ||
| {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_11_46.png?1200|}} | {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_11_46.png?1200|}} | ||
| + | <note tip>When you store your parameters, you have to store the macro above you parameters, otherwise the parameters will not be stored</note> | ||
| ===== Create Parameter ===== | ===== Create Parameter ===== | ||
| {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_27.png?400|}} | {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_27.png?400|}} | ||
| Line 20: | Line 22: | ||
| {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_11_25.png?400|}} | {{: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. | + | 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 ===== | ===== Result ===== | ||
| {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_33.png?1200|}} | {{:public:user_s_documents:icon-l:programming_issues:screenshot_-_16.02.2014_13_10_33.png?1200|}} | ||
| Line 26: | Line 28: | ||
| As the result, you see the datas from your excel sheet in iCon-L. | As the result, you see the datas from your excel sheet in iCon-L. | ||
| ===== Combine Vectors to a Matrix ===== | ===== 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|}} | {{: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}} | ||
