Dealing with a tuple

Top  Previous  Next

One may wish to read or write a tuple.  They can be read using SET  (Gdxxrwread.gms)  but DSET cannot be used.

 

$call "Gdxxrw gdxxrwss.xls set=i10 Rng=sheet1!b26:e27 cdim=2"

execute "Gdxxrw gdxxrwss.xls set=i10a Rng=sheet1!b26:e27 cdim=2"

 

and written as follows (Gdxxrwwrite.gms)

 

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=ii Rng=output2!a10  rdim=2 "

execute "Gdxxrw Gdxxrwwrite.gdx o=gdxxrwss.xls set=ii Rng=output2!a20  cdim=2 "

 

where rdim causes the writing to be oriented in rows and cdim in columns.  The written tuple would also be associated with an added row or column containing explanatory text.