Search found 2 matches

by asietr
3 years ago
Forum: Modeling
Topic: Input more 1-D parameters from excel
Replies: 2
Views: 1730

Re: Input more 1-D parameters from excel

Don't use xls2gms. It's a tool on its way out. Use gdxxrw : 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...
by asietr
3 years ago
Forum: Modeling
Topic: Input more 1-D parameters from excel
Replies: 2
Views: 1730

Input more 1-D parameters from excel

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! Set i "The ind...