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 13:09] genzmehr angelegt |
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. | ||
| + | <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 ===== | ||
| + | Assign global paramters to your macro | ||
| + | {{: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 ===== | ||
| + | {{: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}} | ||
