ReadTrnsportData1 : Reads set data and the table of the transportation model in several calls
This program reads transportation data using xls2gms.exe.
Files: Test3.xls ReadTrnsportData1.gms
$ontext
This program reads transportation data using xls2gms.exe.
$offtext
set i /
$call =xls2gms r=Sheet2!a3:a4 i=Test3.xls o=seti.inc
$include seti.inc
/;
set j /
$call =xls2gms r=Sheet2!b2:d2 s="," i=Test3.xls o=setj.inc
$include setj.inc
/;
table d(i,j)
$call =xls2gms r=Sheet2!a2:d4 i=Test3.xls o=pard.inc
$include pard.inc
;
display i,j,d;