You send me a file with xlsx as extension, but your code says xls… ….projdir\problem.xls
Renger
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Sema Ky
Sent: Dienstag, 3. November 2015 12:44
To: gamsworld
Subject: Re: New problem about gdx file.
Thank you for your answer but I still have problem , this is my excel file and also paste my gdx code, only this make me so unhappy
I also use xlsx but have a problem .
$CALL ‘GDXXRW i=C:\Users\SemaK\Documents\Gamsdir\projdir\problem.xls par=dm rng=Sayfa1!A1:F13 dim=3 rdim=1 cdim=2 trace=3’
Parameter dm(st,alfa,t)
$GDXIN problem.gdx
$LOAD dm
$GDXIN
Display dm;
Output of gams :
296 Parameter dm(st,alfa,t) satıs toplama merkezi talep degerleri
**** File: C:\Users\SemaK\Documents\gamsdir\projdir\problem.gdx
**** Msg : No such file or directory
297 $GDXIN problem.gdx
**** $510
298 $LOAD dm
**** $502
300
301 Display dm;
**** $141
On Tuesday, November 3, 2015 at 11:37:28 AM UTC+2, Renger van Nieuwkoop wrote:
Hi Sema
You have the wrong extension in your code for the excel file: it is xlsx not xls.
I always add Trace =3 to the call, so I see directly if there are any errors.
If this is not the problem you are encountering (and I assume it is), gdx probably can’t find the gdx file after correctly generating it.
(probably you have forgotten to create a project for this gams file).
Be sure to send code that will produce your error (in your case it isn’t).
Cheers
Renger
From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Sema Ky
Sent: Montag, 2. November 2015 21:37
To: gamsworld
Subject: New problem about gdx file.
This is my code but It is working , some problem happened, I look at display for dm , All of them looks zero .
$CALL ‘GDXXRW i=C:\Users\SemaK\Documents\Gamsdir\projdir\model.xls par=dm rng=Sayfa1!A20:F32 dim=3 rdim=2 cdim=1’
Parameter dm(st,alfa,t)
$GDXIN model.gdx
$LOAD dm
$GDXIN
Display dm;
Thank you
Sema
255
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
–
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.
–
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.