Error in writing output to excel

Archiver · February 10, 2014, 7:51pm

Hi,

I am attempting to write the output from GAMS into excel.

What i am trying to do is the following

Read a matrix (I,AI) from excel, display it in GAMS and then write it in a sheet of the same excel (from which I read the matrix).

However I get the attached error as shown in the screen shot. Can someone please help me understand what I am doing wrong?

Thanks in advance

–

Archiver · February 11, 2014, 8:36am

Hi Ranjand

You define it as a parameter and try to read it as a variable. Use par= instead of var=

Cheers

Renger

From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of ranjand2005@gmail.com
Sent: Monday, February 10, 2014 7:51 PM
To: gamsworld@googlegroups.com
Subject: Error in writing output to excel

Hi,

I am attempting to write the output from GAMS into excel.

What i am trying to do is the following

Read a matrix (I,AI) from excel, display it in GAMS and then write it in a sheet of the same excel (from which I read the matrix).

However I get the attached error as shown in the screen shot. Can someone please help me understand what I am doing wrong?

Thanks in advance

–
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.

Archiver · February 11, 2014, 2:32pm

Thanks Renger

On Tuesday, 11 February 2014 00:21:00 UTC+5:30, ranja...@gmail.com wrote:

Hi,