Note

This tool is part of the GAMS Tools Library. Please inspect the general information about GAMS Tools.

This tool writes all worksheets of an Excel workbook to GAMS symbols.

Usage

Command line:

gamstool [data.]ExcelDump excelFile gdxOut=fileOut.gdx

Compile time:

$callTool [data.]ExcelDump excelFile [gdxOut=fileOut.gdx]

Execution time:

executeTool '[data.]ExcelDump excelFile [gdxOut=fileOut.gdx]';

Where:

Argument	Description
excelFile	Excel workbook filename

The following named parameters are available:

Parameter	Description
gdxOut=fileOut.gdx	Name of GDX file that contains symbols s, r, c, w, ws, vf, vs, and vu. Mandatory if called from the command line, otherwise optional.

example

Set s            'Workbook sheets'
    r            'Rows'
    c            'Columns'
    w            'Workbook sheets by name'
    l            'Labels'
    ws(s,w)      'Workbook map'
    vs(s,r,c)    'Cells with explanatory text'
    vu(s,r,c,l<) 'Cells with potential GAMS label';
Parameter 
    vf(s,r,c)    'Cells with numerical value';

$callTool.checkErrorLevel data.ExcelDump input.xlsx;
display ws, vs, vu, vf;