how to save all the results into the EXCEL

GAMS
1

Hello everybody,
I can save results into the excel like this:
Execute_Unload “oldMethod.gdx”,y,yy;
Execute ‘GDXXRW.EXE oldMethod.gdx Output=oldMethod.xls var=y.l rng=sheet1!a1 var=yy.l rng=sheet2!a1’;
however,if the result of a variable is 0,gams wont write it to the excel .It is not convinent for me to read it ,
so is there any method can write all the results include 0 to excel.anyone can help me ?Thanks a lot!


Best regards!
Hiking

–
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.

2

Hi

You could, for example, search this forum: “zero gdxxrw” gives about 25 entries…

And then, after that, read the guidelines of this forum…
Cheers

Renger



Von: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] Im Auftrag von qinghai Sun
Gesendet: Wednesday, January 14, 2015 14:02
An: gamsworld@googlegroups.com
Betreff: how to save all the results into the EXCEL



Hello everybody,

I can save results into the excel like this:

Execute_Unload “oldMethod.gdx”,y,yy;

Execute ‘GDXXRW.EXE oldMethod.gdx Output=oldMethod.xls var=y.l rng=sheet1!a1 var=yy.l rng=sheet2!a1’;

however,if the result of a variable is 0,gams wont write it to the excel .It is not convinent for me to read it ,

so is there any method can write all the results include 0 to excel.anyone can help me ?Thanks a lot!





Best regards!

Hiking

–
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.