GDX Utilities

 Top  Previous  Next

There are a number of GDX (GAMS Data Exchange) related utilities that are included with GAMS that work with GDX files.

These are

GDXCOPY

Copies/Converts one or more GDX files to a different format

GDXDIFF

Inspects the data within symbols in two different GDX files that have the same name, type and dimension then writes any cases where differences are found into a third GDX file

GDXDUMP

Writes the contents of a GDX file into a GAMS formatted text file.

GDXMERGE

Combines the data from multiple GDX files into one file. Symbols with the same name, dimension and type are combined into a items with the same symbol name with one additional dimension. The added dimension contains the file name of the file from which the data came from as the set element name.

GDXRANK

Reads one dimensional parameters from a GDX file, sorts each parameter and writes the sorted indices as a one dimensional parameters to the output GDX file.

GDXVIEWER

Moves data from a GDX file and place it a CSV,XLS, XLS, GAMS ,Access, SQL, MS SQL, SQL Insert script, SQL Update script, HTML, or XML.

GDXXRW

Allows reading and writing of data from and to an Excel spreadsheet. This utility requires the presence of Microsoft Excel on the computer and therefore can only be used on a PC running the Windows operating system with Microsoft Excel installed

GDX2ACCESS

Dumps the contents of a GDX file to an MS Access file (.mdb file).

GDX2XLS

Places the contents of an entire GDX file into a Microsoft Excel spread sheet.

MDB2GMS

Takes contents from an Microsoft Access database into either a GAMS Include File or a GAMS GDX File.

SQL2GMS

Takes contents from an SQL database into either a GAMS Include File or a GAMS GDX file.

XLS2GMS

Takes contents from an Excel spreadsheet into either a GAMS include File or a GAMS GDX File.

 

•ASK: The ASK utility is a simple tool to ask simple interactive questions to the end-user. For instance, if your model requires a scalar to be changed regularly, instead of letting the end-user change the .gms source file, it may be better to pop up a window, with a question text, where the required number can be entered → Documentation.
•ShellExecute: ShellExecute is a small wrapper program for the shellexecute Windows API call. It allows you to spawn an external program based on the file type of the document to open → Documentation.