Help with Gams and Excel interfase

questions about GAMS' tools
Post Reply
dgormaz
User
User
Posts: 6
Joined: 8 months ago

Help with Gams and Excel interfase

Post by dgormaz » 8 months ago

Hello.
I want to know how to show my results in excel. I have a lot of variables and I do not know how to show them all without writing them one by one. Also, I tried to do this, and it don't show me all the results:
< Execute_unload "resultados.gdx" F2.L F2.M
execute 'gdxxrw.exe resultados.gdx o=resultados.xls var=F2.L rng=newsheet2!'
execute 'gdxxrw.exe resultados.gdx o=resultados.xls var=F2.M rng=NewSheet!'>
In the spreadsheet it show me this: https://ibb.co/rpd5kxW
And in the lst file it show me this: https://ibb.co/s9VzGVd

I want to know if the reason why I can not see the other values ​​is because there is a '.' in the results (and to know how show all the results without writing them).

Thanks!

User avatar
bussieck
Moderator
Moderator
Posts: 342
Joined: 3 years ago

Re: Help with Gams and Excel interfase

Post by bussieck » 8 months ago

GAMS is a sparse system and it does not store 0 and hence can't write them out to Excel. You will find more posts in the forum how to address this.

-Michael

Post Reply