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 an 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 |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
