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. Also see History notes.
Note: the blank lines below do not exist in the actual file. They are inserted here to make the text more readable.
;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
[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
History
2023 May, A-Shell 6.5.1731, CSV2XL.SBX 2.1(277): Add new ini file option to set footnote references to subscripts:
[Format]
FootnoteSubscripts=1
When set to 1, any occurrences of "(#)" or "(##")—where # represents a digit from 0-9, e.g. "(1)" or "(13)"—in the banner or column titles will be converted to the corresponding subscripted number. Similarly, "#)" or "##)" at the start of a footnote will also be converted. The idea is to mimic the standard typographic handling of footnotes in traditional publishing. Unfortunately, the subscript font may be so small in Excel that they are to read. Consequently it it it remains an option, defaulting off.
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.
