gdxxrw error 343 in

GAMS
1

Good morning colleagues,

I have a problem that when I run the model I get what you see in the image.
image.png
Previously it worked correctly.

attached .gms and excel document

Thanks for your help.
Octubre.gms (1.97 KB)
ensayo.xlsx (110 KB)

2

Is it possible to export GDX files from the GAMS Studio directly into an alternative format, such as a virtual reality environment, to enhance the visualization and exploration of optimization results?

3

if normally if you use the following syntax you can pass an xls to gdx and have the excel data in gams.
$onecho > intext.txt
dset=i rng=Datos!g4 rDIM=1
par=hdata rng=Datos!h3:L171 rDim=1 cDim=1
$offEcho
$call.checkErrorLevel GDXXRW.exe I=ensayo1.xlsx O=ensayo1.GDX trace=3 @intext.txt
$gdxin ensayo1.gdx
$load i hdata

4

Hi,

I cannot reproduce the issue mentioned in the initial post. Please note that Excel has to be installed and activated for gdxxrw to work.

I hope this helps!

Fred

5

Good morning FRED.
After many attempts I was able to solve the problem, it was simply that it was not taking all the boxes in excel, it was taking from where the numbers were and not the part of the labels.

Thank you very much. Sebastian G