Note

The Windows GAMS distribution contains several tools to exchange data with MS-Excel: GDX2XLS, GDXXRW, XLS2GMS, and XLSDUMP. While we continue to include all four tools in our distribution, only GDXXRW is under active development. Therefore, we strongly recommend using GDXXRW for data exchange with Excel.

This program will write all worksheets of an Excel workbook to a gdx file. Unlike GDXXRW, the program does not require that Excel is installed. Windows platforms only.

Usage

XLSDump infile outfile

where

infile

A valid Excel workbook

outfile

Optional. The output gdx file. If no output file is specified, the name of the input file will be used to construct the name the output file.

Example

Consider the following working file 'test2.xlsx'.

Original workbook test2.xlsx

Converting this workbook using xlsdump:

xlsdump test2.xlsx

Will generate the file test2.gdx. Showing this gdx file in the GAMS IDE:

Contents of test2.gdx

The parameter VF:

Parameter VF (values)