gams 从表格中读取 写入数据

gams 文件;

*read data from xls
*first read in gdx and then use these data for function

*------------------------------------------------------------------------------
*read data use following statement  ;there are two ways, the second is write the parameters in a .txt
*it is helpful to read for code

*$call "gdxxrw.exe transport.xls  output = transport1.gdx dset = i rng=a3:a4 Rdim=1  dset=j rng=b2:d2 cdim=1  par=d rng=A2" ;
$call "gdxxrw.exe transport.xls  output = transport1.gdx @parameters.txt" ;

$gdxin transport1.gdx
      Sets
        i (*) ,
        j(*) ,
        i1(*) ;
      parameters
        d(i,j)
        d1(i);

*do not need ; in the end of the line
$load i  j
      display i, j;
$load d
      display d;
$load i1
       display i1;
$gdxin

*--------------------