Writing results to Excel

Problems with syntax of GAMS
Post Reply
Job
User
User
Posts: 5
Joined: 8 months ago

Writing results to Excel

Post by Job » 6 months ago

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: 95
Joined: 1 year ago

Re: Writing results to Excel

Post by cladelpino » 6 months ago

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: 5
Joined: 8 months ago

Re: Writing results to Excel

Post by Job » 6 months ago

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