GDXXRWExample7 : Reads a four dimensional parameter from an MS Excel file and writes it to a GDX file
This program illustrates reading a four dimensional parameter.
Files: Test1.xls GDXXRWExample7.gms
<![CDATA[
$ontext
This program illustrates reading a four dimensional parameter.
$offtext
sets a first row entries /a1,a2/
b second row entries /b1,b2/
q first column entries /q1,q2/
r second column entries /r1,r2/ ;
parameter data3(a,b,q,r);
$CALL GDXXRW Test1.xls par=data3 rng=EX3!A1:F6 Rdim=2 Cdim=2
$GDXIN Test1.gdx
$LOAD data3
$GDXIN
display data3;
]]></plaintext></body></div>