Gams World email discussion groups moved to Google group gamsworld

Dear GAMS World member,

Driven by some user requests we are going to close the email lists
cone-l, global-l, minlp-l, mpec-l, mpsge-l, and perform-l and
consolidate the discussion on GAMS World by opening a Google group
called gamsworld. We have automatically signed up all existing members
to this Google group. All subscribed members should have received an
email how to complete their subscription to the gamsworld Google group.

Regards,
Your GAMS World Team


–~–~---------~–~----~------------~-------~–~----~
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
-~----------~----~----~----~------~----~------~–~—

Hi
How to export data from a GDX file to different sheets in a excel book using the GDXXRW OPTION?

I wrote the below furnished command, but I could not identify where lies the error in it, since the excel sheet doesn’t show any of the data/values of the parameter

EXECUTE ‘GDXXRW.EXE EG2.GDX VAR= K.L RNG= SHEET2! DIM=1, RDIM=2’
whereas
EXECUTE ‘GDXXRW.EXE EG2.GDX VAR= K.L’ works and the excel sheet shows the data.
I want to write the parameter values of different parameters from the GDX file to different sheets in a excel workbook.

I will appreciate if anyone of you can help me out.

Thank you.

Regards
Pooja



On Monday, October 9, 2006 8:52:06 PM UTC+5:30, Michael Bussieck wrote:

Dear GAMS World member,

Driven by some user requests we are going to close the email lists
cone-l, global-l, minlp-l, mpec-l, mpsge-l, and perform-l and
consolidate the discussion on GAMS World by opening a Google group
called gamsworld. We have automatically signed up all existing members
to this Google group. All subscribed members should have received an
email how to complete their subscription to the gamsworld Google group.

Regards,
Your GAMS World Team


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 Pooja



This works fine:

EXECUTE ‘GDXXRW.EXE EG2.GDX var=K.L RNG=Sheet2!’



You can add trace=3 to see the errors in GDX in your output window. EXECUTE ‘GDXXRW.EXE EG2.GDX var=K.L RNG=Sheet2! Trace=3’



This would have probably given you an indication, where the problem lies. But as you didn’t provide enough information on K, it is hard to guess, what went wrong, so please, always send enough information, so one can reproduce the error (see the guidelines to this forum).


Cheers


Renger


Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch











From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of pooja padmanabhan
Sent: Donnerstag, 21. November 2013 07:04
To: gamsworld@googlegroups.com
Subject: Re: Gams World email discussion groups moved to Google group gamsworld



Hi

How to export data from a GDX file to different sheets in a excel book using the GDXXRW OPTION?



I wrote the below furnished command, but I could not identify where lies the error in it, since the excel sheet doesn’t show any of the data/values of the parameter



EXECUTE ‘GDXXRW.EXE EG2.GDX VAR= K.L RNG= SHEET2! DIM=1, RDIM=2’

whereas

EXECUTE ‘GDXXRW.EXE EG2.GDX VAR= K.L’ works and the excel sheet shows the data.

I want to write the parameter values of different parameters from the GDX file to different sheets in a excel workbook.



I will appreciate if anyone of you can help me out.



Thank you.



Regards

Pooja






On Monday, October 9, 2006 8:52:06 PM UTC+5:30, Michael Bussieck wrote:

Dear GAMS World member,

Driven by some user requests we are going to close the email lists
cone-l, global-l, minlp-l, mpec-l, mpsge-l, and perform-l and
consolidate the discussion on GAMS World by opening a Google group
called gamsworld. We have automatically signed up all existing members
to this Google group. All subscribed members should have received an
email how to complete their subscription to the gamsworld Google group.

Regards,
Your GAMS World Team


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.