GDXXRWExample8 : Reads a parameter with special values from an MS Excel file and writes it to a GDX file
This program illustrates reading a parameter with
special values such Eps, +Inf, -Inf, etc.
Files: Test1.xls GDXXRWExample8.gms
<![CDATA[
$ontext
This program illustrates reading a parameter with
special values such Eps, +Inf, -Inf, etc.
$offtext
sets v column entries /v1,v2,v3,v4,v5,v6/ ;
parameter data4(v);
* $onUNDF must be set in order to read #DIV/0!
$onUNDF
$CALL GDXXRW Test1.xls par=data4 rng=EX4!A1:F2 Cdim=1
$GDXIN Test1.gdx
$LOAD data4
$GDXIN
display data4;
]]></plaintext></body></div>