Hello I am new in gams. I saved my data in excel format that was very huge. It was in two sheets in 1045 column in 952 rows. I ask software that shows result in tow sheets named X and Y (that each of them be in 1045 column in 952 row). When I ran my model it seems to be solved but I can’t receive output. Gams shows something like error (Adding new sheet. Data exceeds range for X and Y). What is it? How can I show output?

asked 24 Jul '14, 07:00

fatema's gravatar image

accept rate: 0%

It seems that "Data exceeds range for X and Y" states that the dimensions of your exported data do not match the dimensions of the ranges you have already defined in your Excel file. Make sure that the dimensions of both sides are correct and match each other. If that doesn't help, upgrading your GAMS system to a version later than 23.6.5 and using XLSX file format might help. According to here, GAMS has had previously some problems with very large exported data and the XLS file format. Although, that does not seem to be your case. Finally, I recommend to post your question on GAMS-L and GAMSWORLD Google group for a better chance of help.


answered 29 Jul '14, 04:39

Ehsan's gravatar image

Ehsan ♦
accept rate: 16%

Hello. Thanks Ehsan. I change .XLS format to .XLSX and it works. Thank you alot

(30 Jul '14, 08:48) fatema
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 24 Jul '14, 07:00

Seen: 4,371 times

Last updated: 30 Jul '14, 08:48

OR-Exchange! Your site for questions, answers, and announcements about operations research.