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

 

_img90

 

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"