Writing results to Excel

Problems with syntax of GAMS
Post Reply
Job
User
User
Posts: 6
Joined: 6 years ago

Writing results to Excel

Post by Job »

I declared a set as IOZ(sec,secc) and sent the results of an analysis to it. The results display well on the screen but I get error 148 when I tried to create a file with this command
Parameter
result9(*,*) Results reporting
;
result9("IOZ") =IOZ;
Can any one help?
cladelpino
User
User
Posts: 108
Joined: 7 years ago

Re: Writing results to Excel

Post by cladelpino »

Hi:

What do you want to accomplish ? Why not directly write the set IOZ to the file?

A parameter is intended to store a value mapped to each element of a set.

Good luck
Job
User
User
Posts: 6
Joined: 6 years ago

Re: Writing results to Excel

Post by Job »

Okay, thanks. But I tried it without success. Eventually this worked:

Parameter
result9b(*,*) Results reporting
;

result9b(sec,secc) =IOZ(sec,secc);
i.e. passing the sets dimensions to each side.
Post Reply