Hello,
I am trying to write my variables results (.L) without printing the header (corresponding to the sets). Let's say i have x(t) with t from 1 to 24, and in excel i only want the x(t) values to be written, but what i get with GDXXRW is that i get the headers 1, 2, ... 24 printed.
i tried with cdim and rdim=0 and i can't figure out a solution. Is this possible?
Thanks in advance
GDXXRW - writing to excel - no header
Re: GDXXRW - writing to excel - no header
Hi
As far as I know, this is not possible, but why should you want to do this? Why do the labels bother you?
Cheers
Renger
As far as I know, this is not possible, but why should you want to do this? Why do the labels bother you?
Cheers
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Re: GDXXRW - writing to excel - no header
Hi Renger and thanks for the feedback.
That would be just a matter of organizing the data straight from GAMS to the "right" place in the spreadsheet in order to make it easier for tables, plots and so on. But i can just upload stuff there and use referencing instead.
That would be just a matter of organizing the data straight from GAMS to the "right" place in the spreadsheet in order to make it easier for tables, plots and so on. But i can just upload stuff there and use referencing instead.
Re: GDXXRW - writing to excel - no header
Hi,
if it is about getting the values into the right place, you might want to use the "merge" option of gdxxrw, like described here: https://www.gams.com/latest/docs/T_GDXX ... HEET_MERGE
Best,
Lutz
if it is about getting the values into the right place, you might want to use the "merge" option of gdxxrw, like described here: https://www.gams.com/latest/docs/T_GDXX ... HEET_MERGE
Best,
Lutz