GDXXRWExample9 : Reads a set using 'values' option from an MS Excel file and writes it to a GDX file
This program illustrates reading a set from an Excel
spreadsheet with using 'values' option.
Files: Test1.xls GDXXRWExample9.gms
$ontext
This program illustrates reading a set from an Excel
spreadsheet with using 'values' option.
$offtext
set set1;
$CALL GDXXRW Test1.xls set=SET1 values=yn rng=EX5!A2:B6 Rdim=1
$GDXIN Test1.gdx
$LOAD set1
$GDXIN
display set1;