GAMS [ Home | Downloads | Documentation | Solvers | APIs | Tools | Model Libraries | Resources | Sales | Support | Contact Us | Search ]

XLSDUMP

Table of Contents

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'.

xlsdump1.png
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:

xlsdump2.png
Contents of test2.gdx

The parameter VF:

xlsdump3.png
Parameter VF (values)