A number of options for writing symbols to a XLS file can be specified in an .ini file. An .ini file can be be created / edited using the GAMSIDE or any other text editor. See also location of ini file.
The ini file has two sections; settings and colors. The table below summarizes the available options:
section
|
key
|
type
|
default
|
remarks
|
settings
|
autofilter
|
bool
|
true
|
Generate autofilter enabled tables
|
|
eps
|
string
|
EPS
|
String for the Eps value
|
|
freezeheader
|
bool
|
true
|
Keep headers fixed so they do not scroll off the screen
|
|
indexformat
|
string
|
|
Custom format for index columns
|
|
inf
|
string
|
INF
|
String for the +Inf value
|
|
mininf
|
string
|
-INF
|
String for the -Inf value
|
|
mintoc
|
integer
|
5
|
Minimum number of symbols needed to generate a table of contents; see also toc
|
|
na
|
string
|
NA
|
String for the NA value
|
|
scalarsheet
|
bool
|
true
|
Generate a separate sheet for all scalar symbols (dim=0)
|
|
sorttoc
|
bool
|
true
|
|
|
tableformatting
|
bool
|
false
|
Embellish tables with fonts and colors
|
|
toc
|
bool
|
true
|
Generate a table of contents for all symbols; see also mintoc
|
|
undf
|
string
|
UNDF
|
String for the UNDF value
|
|
valueformat
|
string
|
|
Custom format for value columns
|
colors
|
body
|
integer
|
19
|
Color index for the background of a table
|
|
header
|
integer
|
24
|
Color index for the background of a table header
|
|
italics
|
integer
|
48
|
Color index for writing explanatory text
|
[settings]
eps=0
scalarsheet=1
[colors]
header=17
|
The configuration file used, if any, is determined in three steps:
1. If the file <xlsfile>.ini exists, use that file
2. If the file <gdxfile>.ini exists, use that file
3. If the file gdx2xls.ini exists in the GAMS system directory, use that file
|