GAMS [ Home | Support | Sales | Solvers | Documentation | Model Libraries | Search | Contact Us ]

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;