Errors in loading data from Excel

GAMS
1

Dear Gams friend,

I tried to load data from Excel. I got the error message-unable to open gdx file and gdxin file not open. is it necessary to install gdx utility/software? I have attached the EXCEL file and GAMS code.


Regards,
Syed

–
shimul.xlsx (9.21 KB)
practicalshimul.gms (235 Bytes)

2

Your code has “shimul.xls” whereas your file is in “xlsx” format.





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Syed Ali
Sent: Wednesday, November 13, 2013 12:40
To: gamsworld@googlegroups.com
Subject: Errors in loading data from Excel



Dear Gams friend,

I tried to load data from Excel. I got the error message-unable to open gdx file and gdxin file not open. is it necessary to install gdx utility/software? I have attached the EXCEL file and GAMS code.


Regards,
Syed

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.


CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.

\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

3

I also tried to run by changing the excel file to .xls format or changing in code as shimul.xlsx and found the same errors.

On Wednesday, November 13, 2013 8:57:22 PM UTC+9, mmarinucci wrote:



Your code has “shimul.xls” whereas your file is in “xlsx” format.





From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Syed Ali
Sent: Wednesday, November 13, 2013 12:40
To: gams...@googlegroups.com
Subject: Errors in loading data from Excel



Dear Gams friend,

I tried to load data from Excel. I got the error message-unable to open gdx file and gdxin file not open. is it necessary to install gdx utility/software? I have attached the EXCEL file and GAMS code.


Regards,
Syed

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.


CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.

\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

4

Hi Syed



First of all, you have the range wrong. It should start at A3, so Gams can read the column and row element names.

Secondly, you have defined the parameter over x and y, but the data is arranged over y and x



Cheers



Renger

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch











From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Syed Ali
Sent: Mittwoch, 13. November 2013 13:21
To: gamsworld@googlegroups.com
Subject: Re: Errors in loading data from Excel



I also tried to run by changing the excel file to .xls format or changing in code as shimul.xlsx and found the same errors.

On Wednesday, November 13, 2013 8:57:22 PM UTC+9, mmarinucci wrote:



Your code has “shimul.xls” whereas your file is in “xlsx” format.





From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Syed Ali
Sent: Wednesday, November 13, 2013 12:40
To: gams...@googlegroups.com
Subject: Errors in loading data from Excel



Dear Gams friend,

I tried to load data from Excel. I got the error message-unable to open gdx file and gdxin file not open. is it necessary to install gdx utility/software? I have attached the EXCEL file and GAMS code.


Regards,
Syed

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.




CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

5

Owww. It now works dear Renger. here is the code that works. Great.!

set i /x1x10/
j /y1y10/
;

parameter xydata(j,i);

$CALL GDXXRW.exe shimul.xls par=xydata rng=exampractice!A3:K13 Cdim=1 Rdim=1
$GDXIN shimul.gdx
$LOAD xydata
$GDXIN

Display xydata;





On Wed, Nov 13, 2013 at 9:34 PM, Renger van Nieuwkoop wrote:

Hi Syed



First of all, you have the range wrong. It should start at A3, so Gams can read the column and row element names.

Secondly, you have defined the parameter over x and y, but the data is arranged over y and x



Cheers



Renger

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch











From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Syed Ali
Sent: Mittwoch, 13. November 2013 13:21
To: gamsworld@googlegroups.com
Subject: Re: Errors in loading data from Excel



I also tried to run by changing the excel file to .xls format or changing in code as shimul.xlsx and found the same errors.

On Wednesday, November 13, 2013 8:57:22 PM UTC+9, mmarinucci wrote:



Your code has “shimul.xls” whereas your file is in “xlsx” format.





From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Syed Ali
Sent: Wednesday, November 13, 2013 12:40
To: gams...@googlegroups.com
Subject: Errors in loading data from Excel



Dear Gams friend,

I tried to load data from Excel. I got the error message-unable to open gdx file and gdxin file not open. is it necessary to install gdx utility/software? I have attached the EXCEL file and GAMS code.


Regards,
Syed

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.




CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.

To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.

–
You received this message because you are subscribed to a topic in the Google Groups “gamsworld” group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/gamsworld/M0Md7rmyYbE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.



\

Have fine.
Warm Regards,
Syed Mithun Ali, Assistant Professor, Department of Industrial and Production Engineering, Bangladesh University of Engineering and Technology. Dhaka-1000, Bangladesh.
Mobile no: +8801916034096/+8801718370993
Alternative email: mithun@ipe.buet.ac.bd
http://www.buet.ac.bd/ipe/faculty1.html


\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.