create a GDX file and extract it's whole content to Excel

GAMS
1

Hi Gamsworld!

Is it possible to create a GDX file and extract it’s whole content to
Excel by using the execute ‘gdxxrw.exe’ command?

Like here described here:
http://groups.google.com/group/gamsworld/browse_thread/thread/629680ebf56ca9d/e8256c27080bfd57?hl=en&lnk=gst&q=gdx#e8256c27080bfd57


Thanks

Andreas

\

2

Try this link http://www.gams.com/docs/excel/

On Aug 23, 3:54 pm, Andreas S wrote:

Hi Gamsworld!

Is it possible to create a GDX file and extract it’s whole content to
Excel by using the execute ‘gdxxrw.exe’ command?

Like here described here:http://groups.google.com/group/gamsworld/browse_thread/thread/629680e…

Thanks

Andreas

\

3

Andreas,

Two ways:

  1. Use gdx2xls utility
  2. When viewing the gdx file in the GAMSIDE: Right mouse click in data viewer | Write | Write All symbols to Excel file

–Paul

On Mon, Aug 23, 2010 at 9:54 AM, Andreas S wrote:

Hi Gamsworld!

Is it possible to create a GDX file and extract it’s whole content to
Excel by using the execute ‘gdxxrw.exe’ command?

Like here described here:
http://groups.google.com/group/gamsworld/browse_thread/thread/629680ebf56ca9d/e8256c27080bfd57?hl=en&lnk=gst&q=gdx#e8256c27080bfd57


Thanks

Andreas

–
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.



\

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 post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

4

Use these commands:

execute_unload “myGDX.gdx” ur_parameter(ur_variable); “It creates a GDX file called myGDX.gdx”
execute ‘gdxxrw.exe i=myGDX.gdx o=myEXCEL.xls par=ur_parameter(var=ur_variable
)’;“It write parameters(variables)
to the Excel file”

On Mon, Aug 23, 2010 at 6:24 PM, Andreas S wrote:

Hi Gamsworld!

Is it possible to create a GDX file and extract it’s whole content to
Excel by using the execute ‘gdxxrw.exe’ command?

Like here described here:
http://groups.google.com/group/gamsworld/browse_thread/thread/629680ebf56ca9d/e8256c27080bfd57?hl=en&lnk=gst&q=gdx#e8256c27080bfd57


Thanks

Andreas

–
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

\

To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.