Code: Select all
Set i nodes /1,2,3,4,5,6,7,8,9,10,11,12/;
Parameter Dst(i,i) Distances between two nodes;
$onmulti
$onecho > ficheiroteste.txt
dset=i rng=a1 rdim=1
par=Dst rng=DistanceDur!a1 rdim=1 cdim=1
$offecho
$offmulti
$call GDXXRW InstanzCPLEX_HCSRP_10_2.xlsx trace=3 @ficheiroteste.txt
$GDXIN InstanzCPLEX_HCSRP_10_2.gdx
$LOADm i
$LOAD Dst
$GDXIN
Display Dst;
Code: Select all
Set i nodes;
Parameter Dst(i,i) Distances between two nodes;
$onmulti
$onecho > ficheiroteste.txt
dset=i rng=a1 rdim=1
par=Dst rng=DistanceDur!a1 rdim=1 cdim=1
$offecho
$offmulti
$call GDXXRW InstanzCPLEX_HCSRP_10_2.xlsx trace=3 @ficheiroteste.txt
$GDXIN InstanzCPLEX_HCSRP_10_2.gdx
$LOADm i
$LOAD Dst
$GDXIN
Display Dst;
Can anyone help me? It would be helpful if I could use more than in the Excel file I'm working, so that I could have more sets there, instead of having to create an Excel file for each set.
Thankyou very much!