Customized data interchange links for spreadsheets

Top  Previous  Next

Spreadsheet based data interchange procedures are available for inclusion in GAMS programs that in turn interface with Microsoft Excel.  They are designed to take a GAMS data item and place it in a spreadsheet or retrieve data for a GAMS item from a spreadsheet.  There are four types of interchange procedures available

Those based on Rutherford's utilities Xlexport, Xldump, Xlimport
Those utilizing GDX files through the GAMS Gdxxrw program.
Use of XLS2GAMS
Use of XLSDUMP

Each is discussed.

 

Xlexport, Xldump, Xlimport

Gdxxrw

XLS2GAMS

XLSDUMP

Spreadsheet graphics

Interactively including results