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