problem writing a subset from excel to gams
Posted: Sun Sep 26, 2021 9:36 am
I have a set : x containing x1,x2.
I take it from an excel sheet using following code:
$call GDXXRW o=x.gdx i=x_data.xlsx trace=3 set=x rng=x_set!a1 rdim=1
$GDXIN x.gdx
$LOAD x
$gdxin
Now I have another subset of x : y(x)
How to import it from excel ? And how should I write it in excel? I tried it similar to the parameter , but I am not able to get it from excel to gams. Can you please help me in this
?
I take it from an excel sheet using following code:
$call GDXXRW o=x.gdx i=x_data.xlsx trace=3 set=x rng=x_set!a1 rdim=1
$GDXIN x.gdx
$LOAD x
$gdxin
Now I have another subset of x : y(x)
How to import it from excel ? And how should I write it in excel? I tried it similar to the parameter , but I am not able to get it from excel to gams. Can you please help me in this
?