GDXXRW Error from xls to gdx
GDXXRW Error from xls to gdx
Hi!
It should be some naive error, but after struggling myself for a whole
day, I haven't been able to find it. It used to work but it does not
work anymore.
I have been learning to include data from excel to gams using GDXXRW.
I am trying to move data from xls to gdx. Afterwards, in another step
to move them from gdx to GAMS since the real dataset is huge (this one
is for trials). I have experimented that GAMS reads data quicker from
gdx than from excel directly (using $LIBINCLUDE xlimport). I suspect
that my pc can get struck solving the optimization model because of
the size of the dataset and model design, then I am trying to it
'lighter'.
Here is the code:
============
Sets i units / Depot001*Depot256 /
is(i) selected unit
j inputs and outputs / stock, wages, issues, receipts,
reqs /
ji(j) inputs / stock,
wages /
jo(j) outputs / issues, receipts,
reqs /;
Parameter data(i,j);
execute 'GDXXRW Book1.xls par=data rng=a1:f257 Cdim=1 Rdim=1'
$GDXIN Book1.gdx
$LOAD data=data
$GDXIN
============
At '$LOAD data=data' I get an erorr saying that Book1.gdx is not
found. I have check that GDXXRW has not created the file. Why?
Thank you VERY MUCH in advance.
Best,
Antonio
PS: Book1.xls looks like:
stock wages issues receipts reqs
Depot001 5 4 6 7 8
...
Depot256 1 2 3 4 5
Re: GDXXRW Error from xls to gdx
Antonio.
You run the gdxxrw utility at runtime and you try to import data at
compile time. Since data is a parameter, it does not matter when you
import. Try this:
Parameter data(i,j);
$call GDXXRW Book1.xls par=data rng=a1:f257 Cdim=1 Rdim=1
$GDXIN Book1.gdx
$LOAD data=data
$GDXIN
Hope this helps,
Michael Bussieck - GAMSWorld Coordinator
On Mar 27, 3:16 pm, Antonio wrote:
> > Hi!
> >
> > It should be some naive error, but after struggling myself for a whole
> > day, I haven't been able to find it. It used to work but it does not
> > work anymore.
> >
> > I have been learning to include data from excel to gams using GDXXRW.
> > I am trying to move data from xls to gdx. Afterwards, in another step
> > to move them from gdx to GAMS since the real dataset is huge (this one
> > is for trials). I have experimented that GAMS reads data quicker from
> > gdx than from excel directly (using $LIBINCLUDE xlimport). I suspect
> > that my pc can get struck solving the optimization model because of
> > the size of the dataset and model design, then I am trying to it
> > 'lighter'.
> >
> > Here is the code:
> > ============
> > Sets i units / Depot001*Depot256 /
> > is(i) selected unit
> > j inputs and outputs / stock, wages, issues, receipts,
> > reqs /
> > ji(j) inputs / stock,
> > wages /
> > jo(j) outputs / issues, receipts,
> > reqs /;
> >
> > Parameter data(i,j);
> >
> > execute 'GDXXRW Book1.xls par=data rng=a1:f257 Cdim=1 Rdim=1'
> >
> > $GDXIN Book1.gdx
> > $LOAD data=data
> > $GDXIN
> > ============
> >
> > At '$LOAD data=data' I get an erorr saying that Book1.gdx is not
> > found. I have check that GDXXRW has not created the file. Why?
> >
> > Thank you VERY MUCH in advance.
> >
> > Best,
> >
> > Antonio
> >
> > PS: Book1.xls looks like:
> > stock wages issues receipts reqs
> > Depot001 5 4 6 7 8
> > ...
> > Depot256 1 2 3 4 5