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]
;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
History
2021 May, A-Shell 6.5.1702: SendToPC=2 forces the file transfer to use the ATE-specific non-FTP transfer protocol. This is useful in environments where (S)FTP is not supported. Option 1 continues to use (S)FTP if the server is not Windows and the file is larger than about 10K.
2021 May, A-Shell 6.5.1702: SaveToDir now supports AMOS-style directories, including ersatz. Previously it only supported native directory notation. If the directory does not exist and cannot be created, it will be ignored.