hi to all of my gams friends …
i transfered my tables from excel to gams by GDXXRW. for example i transfered table 2 dimentional R(a,t) As you can see below : (sets a=a1a2 & t=t1t4)
t1 t2 t3 t4
a1 300 400 350 500
a2 500 700 600 800
and my code is
table R(a,t) products Demand
$ call GDXXRW final4t.xlsx trace=3 par=R rng=sheet1!j1:n3 rdim=1 cdim=1
$GDXIN final4t.gdx
$LOAD R
$GDXIN
display R;
every thing is true Apparently … but this error is occured :
*** error 463 : The column section in the previous table is missing
now where is my fault???
best regards …
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Amin,
replace table R(a,t) products Demand
with
parameter R(a,t) products Demand
HTH,
–Paul
On Sun, Aug 16, 2015 at 2:22 AM, Amin Alizadeh wrote:
hi to all of my gams friends …
i transfered my tables from excel to gams by GDXXRW. for example i transfered table 2 dimentional R(a,t) As you can see below : (sets a=a1a2 & t=t1t4)
t1 t2 t3 t4
a1 300 400 350 500
a2 500 700 600 800
and my code is
table R(a,t) products Demand
$ call GDXXRW final4t.xlsx trace=3 par=R rng=sheet1!j1:n3 rdim=1 cdim=1
$GDXIN final4t.gdx
$LOAD R
$GDXIN
display R;
every thing is true Apparently … but this error is occured :
*** error 463 : The column section in the previous table is missing
now where is my fault???
best regards …
\
Paul van der Eijk
GAMS Development Corporation
Tel : (202) 342-0180 Fax : (202) 342-0181
Email: pvandereijk@gams.com
Web : http://www.gams.com
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
thank you so much dear paul …
good luck.
On Monday, August 17, 2015 at 10:56:32 AM UTC+4:30, Amin Alizadeh wrote:
hi to all of my gams friends …
i transfered my tables from excel to gams by GDXXRW. for example i transfered table 2 dimentional R(a,t) As you can see below : (sets a=a1a2 & t=t1t4)
t1 t2 t3 t4
a1 300 400 350 500
a2 500 700 600 800
and my code is
table R(a,t) products Demand
$ call GDXXRW final4t.xlsx trace=3 par=R rng=sheet1!j1:n3 rdim=1 cdim=1
$GDXIN final4t.gdx
$LOAD R
$GDXIN
display R;
every thing is true Apparently … but this error is occured :
*** error 463 : The column section in the previous table is missing
now where is my fault???
best regards …
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.