Exporting more than one paramaeters to Excel

GAMS
1

I understand that I can export variables and parameters to Excel using GDX file as seen below:

execute_unload “results.gdx” x.L x.M

execute ‘gdxxrw.exe results.gdx var=x.L’
execute ‘gdxxrw.exe results.gdx var=x.M rng=NewSheet!f1:i4’


What if I want to export more than one parameters/variables to the same Excel file? How should I code it?


Thanks in advance…

–
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 search this mailing list to find the answer ( :wink: )or read the gdxutils.pdf in your Gams documentation directory. This file explain several ways for exporting multiple parameters or variables to excel.

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Caglar Utku Guler
Sent: Sonntag, 19. April 2015 09:52
To: gamsworld@googlegroups.com
Subject: Exporting more than one paramaeters to Excel



I understand that I can export variables and parameters to Excel using GDX file as seen below:



execute_unload “results.gdx” x.L x.M

execute ‘gdxxrw.exe results.gdx var=x.L’

execute ‘gdxxrw.exe results.gdx var=x.M rng=NewSheet!f1:i4’



What if I want to export more than one parameters/variables to the same Excel file? How should I code it?



Thanks in advance…

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