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

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;