GAMS program in Excel sheet

Top  Previous  Next

XL2GAMS may also be used to import GAMS instructions.  One can maintain a GAMS program in the spreadsheet and then simply include it in a GAMS program.  For example, in resource.xls I imbed resource.gms (excepting I spaced out the table as one might normally do in Excel  in a24:b33).  Then I include and execute it using the following GAMS program (Xl2gmsresource.gms)

 

$setglobal path "c:\gams\gamspdf\bigone\"

$call =XLS2gms i=%path%resource.xls o=%path%resourceXls2gms.inc

$include %path%resourceXls2gms.inc

 

It appears as if one needs to specify the full path in such a use.