Dear friends,
In GAMS model, I know how import sets and parameters by using xls2gms tool. I want to import them in Table form. Plz anybody help me.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.
Reply-to: gamsworld@googlegroups.com
Hi,
if you have an excel file and you wanna bring it to gams environment, use the following code:
Table x(i,j)
$call =xls2gms r=data!“range of your data on excel” i=“name of your excel file”.xls o="put a desire name ".inc
$include a “put a desire name!”.inc
;
For example:
Table x(i,j)
$call =xls2gms r=data!A1:C13 i=Book.xls o=innn.inc
$include innn.inc
Note that you should put your excel file on the directory of gams. For example if you install gams on drive C, the directory can be:
C:\Users.…\Documents\gamsdir\projdir
On Thursday, July 12, 2012 at 8:10:08 PM UTC+4:30, Dileep Damayyawar wrote:
Dear friends,
In GAMS model, I know how import sets and parameters by using xls2gms tool. I want to import them in Table form. Plz anybody help me.
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/d/optout.