Load dimensions are different!

GAMS
1

Here’s the code I’m using:

set
n scenarios /s0*s27/ ;

$CALL GDXXRW.EXE prob.xls par=jprob rng=sheet1!A1:B28

parameter jprob(n) ;
$gdxin prob
$load jprob
$gdxin

display jprob;


I have attached the excel file I’m using prob.xls

I get the error: Load dimensions are different

Any idea why?
Thanks!

–
prob.xlsx (9.06 KB)

2

Hi Sara



If you add trace=3, you will see the following in your case:



$CALL GDXXRW.EXE prob.xlsx par=jprob rng=sheet1!A1:B28 trace=3



Type Symbol Dim Sheet Data RowHeader ColHeader

Par jprob 2 Sheet1 B2:B28 A2:A28 B1:B1



Gdxxrw assumes a header in B1:B1 (which would be rdim=1 cdim=1).



You have to define the dimensions of the parameter by using rdim=1, where rdim gives you the dimension to be found in the rows.



$CALL GDXXRW.EXE prob.xlsx par=jprob rdim=1 rng=sheet1!A1:B28 trace=3





Hope this helps

Renger





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Sara
Sent: Mittwoch, 3. Juni 2015 13:30
To: gamsworld@googlegroups.com
Subject: Load dimensions are different!



Here’s the code I’m using:



set

n scenarios /s0*s27/ ;



$CALL GDXXRW.EXE prob.xls par=jprob rng=sheet1!A1:B28



parameter jprob(n) ;

$gdxin prob

$load jprob

$gdxin



display jprob;





I have attached the excel file I’m using prob.xls



I get the error: Load dimensions are different



Any idea why?

Thanks!

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.