How not to display the labels, in an Excel export ?

GAMS
1

Hello !
I am looking for a way to export a parameter (parameter(t)) or a variable (variable.l(t)) in Excel, without writing the labels of the set defining the parameter/variable.

Currently, what I have in my Excel sheet is :
parameter
t1 12
t2 7
t3 9

And what I would like is :
parameter
12
7
9

I tried to put “Rdim=1” but it still gives me 2 columns, one with the labels and the other one with the values.

I tried using “merge”, so that gdxxrw only writes the values corresponding to the already existing labels in the excel file,
but for what I want to do, I have the labels in the A column of Excel, and I want the values to appear in column G… so gdxxrw does not see the labels right next to the zone I’m asking (G1:G3).

Thank you 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/groups/opt_out.

\

2

Jacques,

You could overwrite these unwanted labels, but it may be a bad idea to do so.
When your labels change, the sequence of the elements may change, and so
the values you write.

To see what I mean, try:
model 1:
set t /t1, t2, t3/;
parameter P(t);
P(t)=Ord(t);
display P;

model2:
set t /t1, t3, t2/;
parameter P(t);
P(t)=Ord(t);
display P;

–Paul


On Thu, Aug 1, 2013 at 7:02 AM, Jacques wrote:

Hello !
I am looking for a way to export a parameter (parameter(t)) or a variable (variable.l(t)) in Excel, without writing the labels of the set defining the parameter/variable.

Currently, what I have in my Excel sheet is :
parameter
t1 12
t2 7
t3 9

And what I would like is :
parameter
12
7
9

I tried to put “Rdim=1” but it still gives me 2 columns, one with the labels and the other one with the values.

I tried using “merge”, so that gdxxrw only writes the values corresponding to the already existing labels in the excel file,
but for what I want to do, I have the labels in the A column of Excel, and I want the values to appear in column G… so gdxxrw does not see the labels right next to the zone I’m asking (G1:G3).

Thank you 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/groups/opt_out.





\

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

\