Loading by upper left hand corner

Top  Previous  Next

Sets can be addressed just indicating the upper left hand corner as follows (Gdxxrwread.gms)

 

$call "Gdxxrw gdxxrwss.xls se=0 dset=i4 Rng=sheet1!a13 cdim=1"

$call "Gdxxrw gdxxrwss.xls se=0 set=i4a Rng=sheet1!a13 cdim=1"

$call "Gdxxrw gdxxrwss.xls se=0 set=i5 Rng=sheet1!a16 cdim=1"

 

This is best done with the skipempty=0 or se=0 option as otherwise Gdxxrw can read more of the sheet and cause errors.