GAMS World Forum

Finally, I did it! Thank you!

I would like to see the data in *.lst file. And I am using "display" option for that.

Why instead of values I receive "YES" ? How can I change it?

Dear Renger, gdxxrw has helped in reading in all the spread sheets into gdx file. The problem now starts when I want to load, for example, first parameter: "LOAD bNP". It says: "Load dimensions are different". And I have been trying to figure out what I have been doing wrong. I h...

Hi Renger, Thank you for your answer! Yes, you right. I have given up SQL procedure and moved to this: $libinclude xlimport inter_consumpP C:\Users\is\Documents\gamsdir\projdir\Data\DATA_til_GAMS.xlsx bNpjifD!a2:d1362 It succeeded in reading in sheets, but I have found another problem. When GAMS rea...

Dear, I have a problem in reading in all variables from spreadsheet, using SQL2GMS. As you can see below. It can only read 'qaeg' and 'yloraeg' from below code, but not the rest: 'var1','var2','var3' and 'var4'. * specifying axes (sets) and indexes (elements): Set P "Production_Place" /P01...