|
Loading sets from data tables |
Top Previous Next |
|
One may wish to enter a data table and take the sets from it. Given a spreadsheet segment like the following from sheet1 of gdxxrwss.xls
one can take the set across the top with any of the following
$call "Gdxxrw gdxxrwss.xls set=i6 Rng=sheet1!b20:d20 cdim=1" $call "Gdxxrw gdxxrwss.xls dset=i6a Rng=sheet1!b20:d20 cdim=1" $call "Gdxxrw gdxxrwss.xls set=i6c Rng=sheet1!b20:d21 cdim=1"
One can also take a set vertically from Column A as follows (Gdxxrwread.gms)
$call "Gdxxrw gdxxrwss.xls dset=j4 Rng=sheet1!a21:a23 rdim=1" |