|
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. |