Loading rows of set elements

Top  Previous  Next

Suppose I have a list of set elements that I wish to read in a spreadsheet such as the section below from gdxxrwss.xls.

 

_img86

 

Either of the following 2 statements read it and place it into a GDX file at compile time as in Gdxxrwread.gms

 

$call "Gdxxrw gdxxrwss.xls set=i1 Rng=a2:c2 cdim=1"

$call "Gdxxrw gdxxrwss.xls dset=i1a Rng=a2:c2 cdim=1"