Good morning colleagues,
I have a problem that when I run the model I get what you see in the image.
Previously it worked correctly.
attached .gms and excel document
Thanks for your help.
gdxxrw error 343 in
gdxxrw error 343 in
- Attachments
-
- Octubre.gms
- (1.97 KiB) Downloaded 142 times
-
- ensayo.xlsx
- (110.49 KiB) Downloaded 162 times
-
- User
- Posts: 1
- Joined: 2 months ago
Re: GDX Export in studio.
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
Re: gdxxrw error 343 in
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
$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
Re: gdxxrw error 343 in
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
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
Re: gdxxrw error 343 in
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
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 2 months ago, edited 1 time in total.