Error 98 Non-blank character(s) beyond max input line length (40000)

Dear GAMS users,

When I was trying to import an excel file into GAMS, I got the following error message:

98 Non-blank character(s) beyond max input line length (40000)
(check that each line ends with a carriage return)

My excel file is a bit too long 20 rows and 8760 columns. Any ideas are appreciated.

Regards,
Yonas


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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\

Hi Yoni,

As a work around, I would try transposing my table in excel and redefine my variables and parameters accordingly.

HTH
Regards,



On Tue, Jun 11, 2013 at 7:45 PM, Yonas Gebrekiros wrote:

Dear GAMS users,

When I was trying to import an excel file into GAMS, I got the following error message:

98 Non-blank character(s) beyond max input line length (40000)
(check that each line ends with a carriage return)

My excel file is a bit too long 20 rows and 8760 columns. Any ideas are appreciated.

Regards,
Yonas


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?hl=en.
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\

Thanks a lot Mohe.



I really appreciate that J



Bests,

Yonas





From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Moha
Sent: 11. juni 2013 20:53
To: gamsworld@googlegroups.com
Subject: Re: Error 98 Non-blank character(s) beyond max input line length (40000)



Hi Yoni,



As a work around, I would try transposing my table in excel and redefine my variables and parameters accordingly.



HTH

Regards,





On Tue, Jun 11, 2013 at 7:45 PM, Yonas Gebrekiros wrote:

Dear GAMS users,



When I was trying to import an excel file into GAMS, I got the following error message:



98 Non-blank character(s) beyond max input line length (40000)

(check that each line ends with a carriage return)



My excel file is a bit too long 20 rows and 8760 columns. Any ideas are appreciated.



Regards,

Yonas


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?hl=en.
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?hl=en.
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

\