Input more 1-D parameters from excel

Problems with modeling
Post Reply
asietr
User
User
Posts: 2
Joined: 3 years ago

Input more 1-D parameters from excel

Post by asietr »

Hi community,

I have a problem about read input data from excel. I want to read all parameters from excel. I attached 2 picture in the post. One of them now, how I read (there is no problem, I can do it) and other one is what I want. I am looking forward to your helps. Thank you!

Code: Select all

Set
i "The index of orders";

Parameter
f(i) "size of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
p(i) "a unit production time of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
d(i) "due date of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
c(i) "production type of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
The image explain current situation;
now.png
now.png (7.52 KiB) Viewed 1662 times
and this one is what i want to do;
I want.png
I want.png (7.49 KiB) Viewed 1662 times
User avatar
bussieck
Moderator
Moderator
Posts: 1033
Joined: 7 years ago

Re: Input more 1-D parameters from excel

Post by bussieck »

Don't use xls2gms. It's a tool on its way out. Use gdxxrw :

Code: Select all

set i; parameter f(i<), p(i), d(i), c(i);
$call.checkErrorLevel gdxxrw i=data.xls o=data.gdx par=f rng=a2 rdim=1 par=p rng=c2 rdim=1 par=d rng=e2 rdim=1 par=c rng=g2 rdim=1
$gdxin data
$load f p d c
-Michael
asietr
User
User
Posts: 2
Joined: 3 years ago

Re: Input more 1-D parameters from excel

Post by asietr »

bussieck wrote: 2 years ago Don't use xls2gms. It's a tool on its way out. Use gdxxrw :

Code: Select all

set i; parameter f(i<), p(i), d(i), c(i);
$call.checkErrorLevel gdxxrw i=data.xls o=data.gdx par=f rng=a2 rdim=1 par=p rng=c2 rdim=1 par=d rng=e2 rdim=1 par=c rng=g2 rdim=1
$gdxin data
$load f p d c
-Michael
Thank you for your help, I will try!
Post Reply