Listed below are the CSV2XL directives that are placed within the CSV2XL initialization file and apply to all spreadsheets generated with CSV2XL. Following this topic is a sample ini file and, following that, the CSV File Directives that may be inserted into and apply only to specific spreadsheets.
Name and Example |
Description if Needed |
Possible Values (and default) |
|---|---|---|
FORMAT section of ini file |
||
OutputFormat=XLS |
|
XLS, (XLSX) |
HeadersFG=COLOR_BLACK |
Headers text color |
See Specifying Colors; (COLOR_BLACK) |
HeadersBG=COLOR_GRAY25 |
Headers background color |
See Specifying Colors; (COLOR_GRAY25) |
HeadersBold=0 |
|
(1 for Yes), 0 for No |
TotalsBG=COLOR_GRAY25 |
Totals background color |
See Specifying Colors; (COLOR_GRAY25) |
FootnoteSubscripts=1 |
|
1 for Yes, (0 for No) |
Defines the default format for numeric columns |
numfmtid |
|
Identify columns to format as text by title pattern |
See link at left |
|
Associate specific formats with columns by title pattern |
See link at left |
|
SplitCol=# |
Freeze columns |
See CSV File Directive SplitCol for details (default 0) |
SplitRow=# |
Freeze rows |
See CSV File Directive SplitRow for details (default 0) |
DATA section of ini file |
||
AddTotals=1 |
Add line and auto-total any numeric column |
1 for Yes, 0 for No |
Headers=1 |
Treat first line as header |
1 for header/yes, 0 for data/no |
POST section of ini file |
||
SaveToDir= |
|
Directory name , or blank for same as directory as CSV |
SendToPC=0 |
|
0 for No, 1 for FTP, 2 for ATEAPX non-FTP |
SendToDir=%TEMP% |
|
PC folder name like c:\docs\sheets or %Environment Variable% |
Overwrite=0 |
|
1 for Yes, 0 for No |
AppendSeqno=1 |
|
1 for Yes, 0 for No |
Launch=1 |
|
(1 for Yes), 0 for No |
XL section of ini file |
||
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 a unique single-digit number. |
||
1,SetDefaultFont,fontname="Calibri",fontsize=12 |
|
|
|
1 for Yes, (0 for no) |
|
