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 and reproduced below.
Note: the blank lines below do not exist in the actual file. They are inserted here to make the text more readable. Likewise, the section headers are in bold underline below, but of course not in the ini file.
;CSV2XL.INI - Configuration 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, may use &hxxxxxx hex notation for RGB)
;HeadersBG=COLOR_GRAY25
HeadersBG=&hd0e0f0
;Headers bold option (default=1)
HeadersBold=0
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 bold option (default=1)
HeadersBold=0
;SplitRow specifies first row after split (after fixed rows); 0=no, 1=based on headers (default); n = n-1 fixed rows at top
SplitRow=1
;SplitCol specifies first column after fixed columns (default 0); 0/1 = no split, n = n-1 fixed cols at left
SplitCol=0
[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]
;Directory to which output should be saved (blank for same as CSV)
SaveToDir=
;Send output to PC client (1=FTP, 2=ATEAPX non-FTP)
SendToPC=0
;If sending to PC, use this directory
SendToDir=%TEMP%
;Allow replacement of existing XLS{X} output file
Overwrite=0
;Append a sequence number suffix to output file to make it unique
AppendSeqno=1
;Launch spreadsheet application (e.g. Excel) to view output
Launch=1
;The [XL] section may contain up to 9 directives that will act as if inserted at the top of the CSV source file.
;Note that the //XL prefix is dropped, and that each line must start with #, where # is a unique digit from 1-9.
[XL]
1,SetDefaultFont,fontname="Calibri",fontsize=12
;2,SetRGBMode
