Writing set elements

One can save set elements to a spreadsheet called gdxxrwss.xls in rows using the commands (Gdxxrwwrite.gms)

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=i Rng=output2!a1  cdim=1 "

where use of SET generates an associated row of Y entries with explanatory text.  DSET cannot be used.

Similarly one can save the set elements to a spreadsheet in columns using the commands (Gdxxrwwrite.gms)

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=j Rng=output2!a5  rdim=1"

where use of SET ordinarily generates an associated column or row with explanatory text unless the values parameter is defined

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=i rng=output2!a16:d16  cdim=1 values=yn"

where the element and an yes no element indicator will occur.

Finally if the range only leaves room for element names then that is all that will be output as in the statement below.

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=i Rng=output2!a15:c15  cdim=1 "

DSET cannot be used.