GDXXRWExample5

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

GDXXRWExample5 : Reads a two dimensional parameter from an MS Excel file and writes it to a GDX file

This program illustrates reading a table from an Excel
spreadsheet with row and column dimension of magnitude
1.

Files: Test1.xls GDXXRWExample5.gms

$ontext This program illustrates reading a table from an Excel spreadsheet with row and column dimension of magnitude 1. $offtext sets i row entries /i1,i2/ a column entries /a1, a2,a3/ ; parameter data1(i,a); $CALL GDXXRW Test1.xls par=data1 rng=a1:d3 Cdim=1 Rdim=1 $GDXIN Test1.gdx $LOAD data1 $GDXIN display data1;