Links to Other Programs Including Spreadsheets

 Top  Previous  Next

When a modeler wants to link GAMS results or input to other programs, it can be done in several fundamentally different ways.

•GAMS is in charge and data from other programs is to be incorporated into the GAMS program as it starts up.
•GAMS is in charge and data from the GAMS results are to be passed to other programs at the conclusion of the GAMS run.
•GAMS is in charge and the user wants to run another program during a GAMS run.
•GAMS is in charge and the user wishes to pass data interactively to other programs during a run.
•Equations in the user model are defined by an external program.
•Some other program is in charge and the user wants to use GAMS to solve a model.
•A GAMS model needs to be converted to another language for solution.

The first five of these are discussed herein, the other two are discussed in the chapter Controlling GAMS from External Programs.

 

Executing an external program

Passing data from GAMS to other programs

Passing data from other programs to GAMS

Customized data interchange links for spreadsheets

Using equations defined by external programs

 

A wiki is available that provides some information in support of interfacing efforts.  see discussion here