Spreadsheet links

Spreadsheet data may be imported into GAMS via three procedures.  As discussed below one can use procedures that can either read or write spreadsheet data like Xlimport or Gdxxrw.  In addition there is a Windows oriented program Xls2gms that allows you to extract data from an Excel spreadsheet and convert it into a GAMS include file and a program Xldata that reads from Excel files on machines that do not have Excel installed on them.  The read/write Xlimport and Gdxxrw procedures are discussed below.  Here I discuss Xls2gms and XLSDUMP as they can only import data.

One may also deliver all data in a  spreadsheet into a GDX file using XLSDUMP.