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