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)

 

_img91

 

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"