Many of CSV2XL's options are configurable via an initialization file, either the default BAS:CSV2XL.INI or another file specified in the calling interface. The options are mostly either self-explanatory or explained by way of comments in the sample CSV2XL.INI file included with the release, reproduced below:

;CSV2XL.INI - Config file for CSV2XL.SBX

[FORMAT]

;OutputFormat choices: XLS (default), XLSX

OutputFormat=XLS

;Headers Text color (Use COLOR_xxx from libxl:libxl.def; default=COLOR_BLACK)

HeadersFG=COLOR_BLACK

;Headers background color (default=COLOR_GRAY25)

HeadersBG=COLOR_WHITE

;Headers alignment (default=ALIGNH_CENTER)

HeadersAlignH=ALIGNH_LEFT

;Headers bold option (default=1)

HeadersBold=0

;Headers font size option (default=DefaultFontSize)

HeadersFontSize=10

;Headers font (default=DefaultFont)

HeadersFont=Broadway;bg color for totals (if AddTotals; default=COLOR_GRAY25)

TotalsBG=COLOR_GRAY25

;regex pattern applied to col titles to force the column to be treated as text (zip, part #, etc.)

;Example: zip|(part *(no|num|#))|phone

; matches any title containing "zip", "phone", or "part" followed by optional space and then "no","num", or "#"

; matching is case insensitive, not anchored (use ^ and $ for start/end anchoring)

ColTitleTextRegex=zip|(part *(no|num|#))|phone|sku

;Headers horizontal alignment (default = ALIGNH_CENTER)

HeadersAlignH=ALIGNH_LEFT

;Headers bold option (default=1)

HeadersBold=0

;Headers font size option (default=DefaultFontSize)

HeadersFontSize=9

;Headers font (default=DefaultFont)

HeadersFont=Garamond

[DATA]

;AddTotals: 1=yes (add line and auto-total any numeric col)

AddTotals=1

;Headers=0 (treat first line as data); =1 (treat as headers) (default=1)

Headers=1

[POST]

Overwrite=0

SendToDir=

AppendSeqno=1

SaveToDir=

SendToPC=0

Launch=1