Excel Data Utilities

The XLLINK tool had a good run and it is now retired. If you want to move data between GAMS and Excel, you have several options. Here are a few alternative approaches:

GDXXRW This is the most commonly used framework for moving data between GAMS GDX files and Excel (xls and xlsx). It requires an operational copy of Excel. (Updated 2009).
GDX2XLS This is Erwin Kalvalegen's routine for converting GDX data to MS Excel spreadsheets. (Updated 2006)
XLS2GMS This is Erwin Kalvalegen's routine for converting MS Excel spreadsheet data into GDX files. (Posted 2004)
XLSNZ This Visual Basic program provides a "no-frills" approach to extracting numeric data from XLS files into GAMS-readable format (Posted 2006).
GDXXLS This Visual Basic routine provides a means for generating formatted Excel table using data from GDX files. (Posted 2006)
XLWRITE This is a console application for creating XLS files from CSV data. It does not require a copy of Excel, based on the Spreadsheet::WriteExcel library. (Posted 2002)
GAMS2CSV provides some GAMS routines from moving data from GAMS into CSV files. (Posted 2002)
QTOOL Provides some command line tools for performing piecemeal and systematic senstivity analysis of GAMS models. Output from this tool is typically in the form of an Excel pivot table. (Posted 2007)
Here is a simple example of how GAMS can use Excel for comparison of model results. We begin with a batch file which peforms computations with different time horizons:
```
call gams ramsey --horizon=2000 gdx=2000
call gams ramsey --horizon=2010 gdx=2010
call gams ramsey --horizon=2020 gdx=2020
gdxmerge id=cl,il 2000.gdx 2010.gdx 2020.gdx
copy template.xls ramsey.xls
gdxxrw i=merged.gdx o=ramsey.xls par=cl rng=cl clear par=il rng=il clear
start ramsey.xls
```
Here is the GAMS model and the template Excel file which are referenced in the batch file.