Hello,
I am writing to a .gdx file some parameters from my excel file, and I would like to write several of them at once (only one label column, associated with several parameters).
At the moment, I have to write the labels in front of each parameter I want to import.
Ideally, it would look like this in my excel :
label1 parameterA1 parameterB1
label2 parameterA2 parameterB2
label3 parameterA3 parameterB3
(parameterA and parameterB are independant, it is not a matrix)
And I would like to import with $Call, but what would be the correct range to import parameterB ?
For parameterA, I use :
$call Gdxxrw UC.xls par=parameterA rng=a1:b3 rdim=1
How can I import parameterB without re-writing the labels in the excel file ?
Thx !
–
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/groups/opt_out.
Hello again,
Actually, thinking it through, what I just want to do is to import a table, from excel into gdx.
What is the syntax ?
Le vendredi 4 octobre 2013 16:58:33 UTC+2, Jacques a écrit :
Hello,
I am writing to a .gdx file some parameters from my excel file, and I would like to write several of them at once (only one label column, associated with several parameters).
At the moment, I have to write the labels in front of each parameter I want to import.
Ideally, it would look like this in my excel :
label1 parameterA1 parameterB1
label2 parameterA2 parameterB2
label3 parameterA3 parameterB3
(parameterA and parameterB are independant, it is not a matrix)
And I would like to import with $Call, but what would be the correct range to import parameterB ?
For parameterA, I use :
$call Gdxxrw UC.xls par=parameterA rng=a1:b3 rdim=1
How can I import parameterB without re-writing the labels in the excel file ?
Thx !
–
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/groups/opt_out.
OK, actually the only problem is: how can i read such or such column of my gdx table, from gams ?
I have managed to write the table in gdx, but i get errors 495 (load dimensions are different) and 496 (load/unload ident expected) when I try to $load a set or a parameter from the gdx table.
thx !
Le vendredi 4 octobre 2013 16:58:33 UTC+2, Jacques a écrit :
Hello,
I am writing to a .gdx file some parameters from my excel file, and I would like to write several of them at once (only one label column, associated with several parameters).
At the moment, I have to write the labels in front of each parameter I want to import.
Ideally, it would look like this in my excel :
label1 parameterA1 parameterB1
label2 parameterA2 parameterB2
label3 parameterA3 parameterB3
(parameterA and parameterB are independant, it is not a matrix)
And I would like to import with $Call, but what would be the correct range to import parameterB ?
For parameterA, I use :
$call Gdxxrw UC.xls par=parameterA rng=a1:b3 rdim=1
How can I import parameterB without re-writing the labels in the excel file ?
Thx !
–
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/groups/opt_out.