Command line interface CSV to XLS Converter
Common parameters
| /OVERWRITE=1 | Overwrite existing file. |
| /OVERWRITE=0 | Do not overwrite existing file. (Append to existing file). |
| /ASIS | Codepage as is. |
| /ANSI | Convert to ANSI codepage. |
| /OEM | Convert to OEM codepage. |
| /OPEN=1 | Open the output file after conversion. |
| /OPEN=0 | Do not open the output file after conversion. |
| /BATCH | Batch mode. The program does not ask any questions (if possible). |
| /SILENT | Batch mode. The program does not display any windows. |
| /WAIT | Do not close the program at the end. (Wait on the finish page). |
| /LOG | Create a log file in a common repository for application-specific data. A typical path is C:\Documents and Settings\username\Application Data. |
| /STATUS /STATUS=filename.ext | Create a text file with a current status (Conversion In Progress, Successful, Failed, Cancelled etc). By default: %Program dir%\status.log |
CSV/XLS specific parameters
| Drive:\Path\FileName.csv | Source CSV file |
| Drive:\Path\FileName.xls | Target XLS file |
| Drive:\Path\ | Target XLS folder |
| /RECORDS=0 | Do not export records of the table. |
| /OVERWRITETABLE=1 | Overwrite existing table/sheet. (default) |
| /OVERWRITETABLE=0 | Do not overwrite existing table/sheet. |
| /SOURCE=ANSI | |
| /SOURCE=OEM | Encoding of the source file. |
| /TYPE=ANY | Convert to Excel 97-2003 & 5.0/95 (*.xls) |
| /TYPE=2007 | Convert to Excel 2007-2010 (*.xlsx) |
| /AUTODATE /MM.DD.YYYY /DD.MM.YYYY /YYYY.MM.DD | Date format, autodetect or user-defined |
| /FIELDS=? Example: /FIELDS=; Special values: TAB means Tab (0x09) character. PIPE means | character. | Delimiter between fields. |
| /ALLCHAR=1 | All fields will be converted as a string. |
| /ALLCHAR=0 | The program will try to detect types of converted values,
such as Date, Logical, Numeric. There are two parameters that help the program to know what symbols are acceptable in Bollean and Numeric fields. |
