The process by which a CSV file is converted into a spreadsheet can involve many, or perhaps only a few, variables. For example, you might want all of your spreadsheets to use the Calibri eleven-point font. Or perhaps you want all numeric columns to have total lines at the bottom.
Maybe you want to have an explanatory note at the bottom of one particular spreadsheet, or perhaps want a page break to appear after a certain number of rows in that sheet.
The point is that there are things that apply to all spreadsheets, and things that apply only to the current spreadsheet. Variables that are set for all spreadsheets are called ini file directives, and are defined in the initialization (ini) file. Variables that apply to individual spreadsheets are called csv files directives and are defined in the CSV file being processed.
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 |
|
|
|
|
|
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 to which output should be saved, 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) |
|
