|
Loading sets from lists with duplicates |
Top Previous Next |
|
One may wish to extract set elements from a spreadsheet where there is no unique list of elements that can be read but rather a list where the name is repeated. In the example below note that in rows 26 and 27 there are set elements names but they are duplicated (gdxxrwss.xls)
One can read this with DSET as follows (Gdxxrwread.gms)
$call "Gdxxrw gdxxrwss.xls dset=i7 Rng=sheet1!b26:e26 cdim=1" $call "Gdxxrw gdxxrwss.xls dset=i8 Rng=sheet1!b27:e27 cdim=1" |