gdxxrw error 343 in

Problems with syntax of GAMS
Post Reply
sebaslo02
User
User
Posts: 2
Joined: 2 months ago

gdxxrw error 343 in

Post by sebaslo02 »

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.
Attachments
Octubre.gms
(1.97 KiB) Downloaded 95 times
ensayo.xlsx
(110.49 KiB) Downloaded 104 times
Georgetieli
User
User
Posts: 1
Joined: 2 months ago

Re: GDX Export in studio.

Post by Georgetieli »

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?
ограничители опн https://energy-21.ru/katalog/opn/category/opn-20-kv опн 10 12 ухл1
sebaslo02
User
User
Posts: 2
Joined: 2 months ago

Re: gdxxrw error 343 in

Post by sebaslo02 »

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
Fred
Posts: 372
Joined: 7 years ago

Re: gdxxrw error 343 in

Post by Fred »

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
sebaslo02
User
User
Posts: 2
Joined: 2 months ago

Re: gdxxrw error 343 in

Post by sebaslo02 »

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
Last edited by sebaslo02 1 month ago, edited 1 time in total.
Post Reply