ExcelDump
- 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;