execute_unload gdx file and execute xlsx file

GAMS
1

Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

\

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/d/optout.

2

Hi Alex

You didn’t specify the parameters or variables you want to send to the excel file.

Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 14:22
To: gamsworld@googlegroups.com
Subject: execute_unload gdx file and execute xlsx file



Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

–
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/d/optout.

–
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/d/optout.

3

Hi Renger,
yes, this is indeed true.
The variables are the same as for the gdx file:
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario

How shoud this be coded?
I tryed this but it doesnt work

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’,
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario
;

Cheers,
A

From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Sun, 22 Feb 2015 20:56:00 +0000

Hi Alex

You didn’t specify the parameters or variables you want to send to the excel file.

Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 14:22
To: gamsworld@googlegroups.com
Subject: execute_unload gdx file and execute xlsx file



Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

–
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/d/optout.

–
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/d/optout.

–
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/d/optout.

4

Hi Alex

Take a look at the many examples in the gdx manual. You can either use a sheet in excel, write it using a text file.

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 22:21
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file



Hi Renger,
yes, this is indeed true.
The variables are the same as for the gdx file:
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario

How shoud this be coded?
I tryed this but it doesnt work

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’,
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario
;

Cheers,
A

From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Sun, 22 Feb 2015 20:56:00 +0000

Hi Alex

You didn’t specify the parameters or variables you want to send to the excel file.

Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 14:22
To: gamsworld@googlegroups.com
Subject: execute_unload gdx file and execute xlsx file



Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

–
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/d/optout.

\

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/d/optout.

–
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/d/optout.

–
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/d/optout.

5

Hi,

I have adopted this approach. I am suppose to get am excel file, but I only get a gdx file that I cannot open.
What is missing form the code?
Chers
Amanda


$onecho >out.tmp Squeeze=N
par=price rng=price!A1 rdim=2 cdim=1
par=Generation rng=G!A1 rdim=2 cdim=1
par=StartPP rng=Startup!A1 rdim=2 cdim=1
par=Shedding rng=Shed!A1 rdim=2 cdim=1
*par=ShadowFlow_neg rng=Restrict_line_neg!A1 rdim=2 cdim=2
*par=ShadowFlow_pos rng=Restrict_line_pos!A1 rdim=2 cdim=2
par=modelstats rng=stats!A1:B10 rdim=1 cdim=0
par=solvestats rng=stats!D1:E10 rdim=1 cdim=0
par=scenario rng=scenario!A1 rdim=1 cdim=0
$offecho

EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, Generation, StartPP, Shedding,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;



From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Mon, 23 Feb 2015 11:26:01 +0000

Hi Alex

Take a look at the many examples in the gdx manual. You can either use a sheet in excel, write it using a text file.

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 22:21
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file



Hi Renger,
yes, this is indeed true.
The variables are the same as for the gdx file:
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario

How shoud this be coded?
I tryed this but it doesnt work

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’,
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario
;

Cheers,
A

From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Sun, 22 Feb 2015 20:56:00 +0000

Hi Alex

You didn’t specify the parameters or variables you want to send to the excel file.

Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 14:22
To: gamsworld@googlegroups.com
Subject: execute_unload gdx file and execute xlsx file



Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

–
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/d/optout.

\

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/d/optout.

–
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/d/optout.

–
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/d/optout.

–
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/d/optout.

6

Hi Amanda



If something with gdxxrw is not working, you should add Trace = 3 to the line, this will give you information in your output window. In this case it will tell you that it couldn’t find the out.tmp file.

If you check your directory, you will see that you saved a file named “out.tmp squeeze=N”. The onecho command directs the output to what follows after the > . Squeeze=N doesn’t belong here. Onecho is a dos command and has nothing to do with gdxxrw.



Hope this helps

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Dienstag, 24. Februar 2015 17:35
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file



Hi,

I have adopted this approach. I am suppose to get am excel file, but I only get a gdx file that I cannot open.
What is missing form the code?
Chers
Amanda


$onecho >out.tmp Squeeze=N
par=price rng=price!A1 rdim=2 cdim=1
par=Generation rng=G!A1 rdim=2 cdim=1
par=StartPP rng=Startup!A1 rdim=2 cdim=1
par=Shedding rng=Shed!A1 rdim=2 cdim=1
*par=ShadowFlow_neg rng=Restrict_line_neg!A1 rdim=2 cdim=2
*par=ShadowFlow_pos rng=Restrict_line_pos!A1 rdim=2 cdim=2
par=modelstats rng=stats!A1:B10 rdim=1 cdim=0
par=solvestats rng=stats!D1:E10 rdim=1 cdim=0
par=scenario rng=scenario!A1 rdim=1 cdim=0
$offecho

EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, Generation, StartPP, Shedding,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;


From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Mon, 23 Feb 2015 11:26:01 +0000

Hi Alex

Take a look at the many examples in the gdx manual. You can either use a sheet in excel, write it using a text file.

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 22:21
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file



Hi Renger,
yes, this is indeed true.
The variables are the same as for the gdx file:
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario

How shoud this be coded?
I tryed this but it doesnt work

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’,
price, StartPP, Shedding, WindOff, modelstats, solvestats, scenario
;

Cheers,
A

From: renger@vannieuwkoop.ch
To: gamsworld@googlegroups.com
Subject: RE: execute_unload gdx file and execute xlsx file
Date: Sun, 22 Feb 2015 20:56:00 +0000

Hi Alex

You didn’t specify the parameters or variables you want to send to the excel file.

Cheers

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Alex Suish
Sent: Sonntag, 22. Februar 2015 14:22
To: gamsworld@googlegroups.com
Subject: execute_unload gdx file and execute xlsx file



Hi,

from the code below I get only a result.gdx file but not the result.xlsx file.
Do you know what is missing to generate the .xlsx file?

thanks
A



EXECUTE_UNLOAD ‘%resultdir%%result%.gdx’, price, StartPP, Shedding, WindOff,
, modelstats, solvestats, scenario;

EXECUTE ‘gdxxrw %resultdir%%result%.gdx o=%resultdir%%result%.xlsx EpsOut=0 @out.tmp’;

–
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/d/optout.

\

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/d/optout.

–
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/d/optout.

\

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/d/optout.

–
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/d/optout.

–
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/d/optout.