How to write a SET in EXCEL

GAMS
1

I want to write the resulting set in excel, how can I do it?

I wrote this but I don’t know if it is the correct way to do it. Also when I try to write the result of a variable x it erases the previous set although I specify different ranges. It basically obligates me to execute two different excel files. But I want to put all data in the same excel file.

Please help me.



execute_unload “EXEMPLO.gdx” DN;

execute ‘gdxxrw.exe EXEMPLO.gdx set=DN.L’;
execute ‘gdxxrw.exe EXEMPLO.gdx set=DN.M rng=NewSheet!f1:i4’;

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

2

Hi DT

This writes the DN.L in sheet1 and DN.M in NewSheet. No erasing. But if you want to make sure that this works, why don’t you explicitly tell GAMS where to put DN.L with its own range (if there is no range and sheet, gams puts the stuff in sheet1 at A1)

Cheers

Renger




\

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch







From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of DT
Sent: Montag, 30. September 2013 19:24
To: gamsworld@googlegroups.com
Subject: How to write a SET in EXCEL



I want to write the resulting set in excel, how can I do it?



I wrote this but I don’t know if it is the correct way to do it. Also when I try to write the result of a variable x it erases the previous set although I specify different ranges. It basically obligates me to execute two different excel files. But I want to put all data in the same excel file.



Please help me.







execute_unload “EXEMPLO.gdx” DN;



execute ‘gdxxrw.exe EXEMPLO.gdx set=DN.L’;

execute ‘gdxxrw.exe EXEMPLO.gdx set=DN.M rng=NewSheet!f1:i4’;

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.