# INI File Directives

> [HTML Version](ini-file-directives.htm)

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](samplecsv_ini_file.htm.md) and, following that, the [CSV File Directives](csv_file_directives.htm.md) 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](specifying-colors.htm.md); (COLOR\_BLACK) |
| HeadersBG=COLOR\_GRAY25 | Headers background color  | See [Specifying Colors](specifying-colors.htm.md); (COLOR\_GRAY25) |
| HeadersBold=0 |  | (1 for Yes), 0 for No |
| TotalsBG=COLOR\_GRAY25 | Totals background color | See [Specifying Colors](specifying-colors.htm.md); (COLOR\_GRAY25) |
| FootnoteSubscripts=1 |  | 1 for Yes, (0 for No) |
| [NumFormat](numformat.htm.md) | Defines the default format for numeric columns | numfmtid |
| [ColTitleTextRegex](formatbycolumntitle.htm.md) | Identify columns to format as text by title pattern | See link at left |
| [ColTitleFormatRegex](formatbycolumntitle.htm.md) | Associate specific formats with columns by title pattern | See link at left |
| SplitCol=# | Freeze columns | See CSV File Directive [SplitCol](csv2xldirectivesdetail.htm.md#csv2xl-splitrowcol) for details (default 0) |
| SplitRow=# | Freeze rows | See CSV File Directive [SplitRow](csv2xldirectivesdetail.htm.md#csv2xl-splitrowcol) 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 |  | 2 for Yes, 1 for Warn, 0 for No |
| AppendSeqno=1 |  | 1 for Yes, 0 for No. Add a sequential number suffix to the filename to avoid overwriting a prior version. For help determining the filename created, see the [SOSLIB function Fn'FileAgeLatest\$())](https://bitbucket.org/microsabio/soslib/src/master/907010/fnfileage.bsi). |
| 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 | |  |
| [SetRGBMode](specifying-colors.htm.md)=0 |  | 1 for Yes, (0 for no) |