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.