Hi everybody!
I hope that you can help me:
I’ve created a model that read some parameters from xls file.
code:
$CALL GDXXRW.EXE C:\Users\Valentina\Documents\gamsdir\projdir\CostsEnrgCapPlan.xls par=Installed_CAP rng=ExistingCap!B2:G39
Parameter Installed_CAP(t,tech)
$GDXIN CostsEnrgCapPlan.gdx
$LOAD Installed_CAP
$GDXIN
Evertything works fine but:
if, after running GAMS 1 time I edit some values in the .xls file these change will not appear in the gdx file when I run the second time GAMS…why? it seems that GAMS does’t rewrite the .gdx file every run. everytime that I change a value in the xls file I have to delete the .gdx file… O.o
Does it exists a code string that allow me to re-write every run the .gdx file?
thanks!!
Valentina
–
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/groups/opt_out.
Hi Valentina
Hard to say what is going on. Gdxxrw should read in the data. Try to run the command with trace=3 at the end, then you will see what is happening.
Cheers
Renger
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Valentina Rosa
Sent: Montag, 25. November 2013 14:31
To: gamsworld@googlegroups.com
Subject: update the GDX file in GAMS dir
Hi everybody!
I hope that you can help me:
I’ve created a model that read some parameters from xls file.
code:
$CALL GDXXRW.EXE C:\Users\Valentina\Documents\gamsdir\projdir\CostsEnrgCapPlan.xls par=Installed_CAP rng=ExistingCap!B2:G39
Parameter Installed_CAP(t,tech)
$GDXIN CostsEnrgCapPlan.gdx
$LOAD Installed_CAP
$GDXIN
Evertything works fine but:
if, after running GAMS 1 time I edit some values in the .xls file these change will not appear in the gdx file when I run the second time GAMS…why? it seems that GAMS does’t rewrite the .gdx file every run. everytime that I change a value in the xls file I have to delete the .gdx file… O.o
Does it exists a code string that allow me to re-write every run the .gdx file?
thanks!!
Valentina
–
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/groups/opt_out.
–
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/groups/opt_out.