dispay results in a pre-existing excel file

GAMS
1

Hi All,

I am relatively new to GAMS.

I have 2 issues to solve with my results.

  1. Results are displayed in an Excel file orizontally

h1 h2 h3
3 64 98

while I need them to be dispalyed vertically
h1 3
h2 64
h3 98

  1. from those results I need the second coloumn (3, 64, 98, …) to be displayed in an exisitng Excel file called “results_CNORD_2013.gdx” (in a specific sheet called “produciton” and specific coulumn E2:E8761)

here is the code I use for the results.

display production.L ;

execute_unload “results_CNORD_2013.gdx”, production;
execute ‘gdxxrw results_CNORD_2013.xlsx Squeeze=N, var=produciton Rng=“Prod”!e2:e8761 Rdim=1’;


Can anybody help?
THanks
Amanda,


\

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 Amanda

Replace Rdim by Cdim

I would put them somewhere else and then link the values in Excel to the cells E2:E8761

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of amanda2007
Sent: Sunday, January 4, 2015 10:52
To: gamsworld@googlegroups.com
Subject: dispay results in a pre-existing excel file



Hi All,



I am relatively new to GAMS.



I have 2 issues to solve with my results.


\

  1. Results are displayed in an Excel file orizontally



    h1 h2 h3

3 64 98



while I need them to be dispalyed vertically

h1 3

h2 64

h3 98



2. from those results I need the second coloumn (3, 64, 98, …) to be displayed in an exisitng Excel file called “results_CNORD_2013.gdx” (in a specific sheet called “produciton” and specific coulumn E2:E8761)



here is the code I use for the results.



display production.L ;


execute_unload “results_CNORD_2013.gdx”, production;
execute ‘gdxxrw results_CNORD_2013.xlsx Squeeze=N, var=produciton Rng=“Prod”!e2:e8761 Rdim=1’;





Can anybody help?

THanks
Amanda,






\

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.