GDXXRW - writing to excel - no header

questions about GAMS' tools
Post Reply
ferrib
User
User
Posts: 6
Joined: 1 month ago

GDXXRW - writing to excel - no header

Post by ferrib » 1 week ago

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

User avatar
Renger
Posts: 186
Joined: 2 years ago

Re: GDXXRW - writing to excel - no header

Post by Renger » 6 days ago

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

ferrib
User
User
Posts: 6
Joined: 1 month ago

Re: GDXXRW - writing to excel - no header

Post by ferrib » 6 days ago

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.

Lutz
User
User
Posts: 23
Joined: 2 years ago

Re: GDXXRW - writing to excel - no header

Post by Lutz » 5 days ago

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

Post Reply