XLSDUMP

Table of Contents

Attention
XLSDump is deprecated (see GAMS 42 XLSDump release notes). Please use Connect agent RawExcelReader instead.

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)