Configuration file for writing to XLS file

Top  Previous  Next

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

 

Example of a configuration file:

 

[settings]

eps=0

scalarsheet=1

[colors]

header=17

 

Location of the configuration file

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