About using GDXXRW

GAMS
1

Hi! members!
I want to import parameter data from Excel to Gams. So, I programmed gams as below.
There was no error but Range of Parameter Am(p) was designated as not inform!g5:g85,n5:n85 but inform!g5:g85, h5:h85.

How can I program separated Excel range?

$onecho > parameter.txt
par=Am rng=inform!g5:g85, n5:n85 Rdim=1
…
$offecho

$call GDXXRW ykraws.xlsx@parameter.txt trace=3
$gdxin ykraws.gdx

parameter
Am(p)
$load Am
$gdxin
;

–
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.

2

Hi Youngki



It looks like you want to import a parameter from excel where the data is in two separate columns. This is not possible.

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of YOUNGKI CHOI
Sent: Donnerstag, 27. Februar 2014 02:10
To: gamsworld@googlegroups.com
Subject: About using GDXXRW



Hi! members!

I want to import parameter data from Excel to Gams. So, I programmed gams as below.

There was no error but Range of Parameter Am(p) was designated as not inform!g5:g85,n5:n85 but inform!g5:g85, h5:h85.



How can I program separated Excel range?


\

$onecho > parameter.txt

par=Am rng=inform!g5:g85, n5:n85 Rdim=1

…

$offecho



$call GDXXRW ykraws.xlsx@parameter.txt trace=3

$gdxin ykraws.gdx



parameter

Am(p)

$load Am

$gdxin

;

–
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.

–
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.

3

I appreciate your reply, Renger.
It looks like I am about to find out another way.

Regards

\