Convert XLS (Excel) files from the command line to other formats

Convert XLS via command line

Single xls file conversion

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" file.xls outfile.ext [OPTIONS]

example:
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" file.xls out.csv

Convert multiple xls files at once (Batch conversion)

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" *.xls destdir /TOEXT [OPTIONS]

where ext - (.dbf, .txt, .htm, .prg, .xml, .xls, .csv, .sql, .rtf)
example
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" c:\mybase\*.dbf c:\out\ /TOXLS

Common options

/LOG|/LOG:logfile - generate log file
xlscnv.exe sample.xls sample.xls /LOG /SKIPD - skip deleted records

/HDR - for put the fields names in first line.

/LF - use LF(0xA) as row delimiter (useful for unix systems), default: CRLF
/REVERSE - export in reverse order

/COLUMNS - set columns for export
syntax:
/COLUMNS:field1[:newname],field2[:newname]

example 1
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.xls out.dbf /COLUMNS:CUST_NO:custom numbers,NAME:custom name

example 2
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.xls sample.csv /COLUMNS:NAME,STREET

/COLUMNSLIST - set columns for export from text file
example:
xlscnv.exe sample.xls sample.csv /COLUMNSLIST:columns
where columns - text file with column names (one per line)

/FILTER:filterfile

filter file format:

Field name:Value|Expression

Examples:

single file conversion:

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" mybase.dbf out.txt /SEP;

multiple file conversion:

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" c:\base\*.dbf c:\exports\ /TOSQL

Text/CSV options
/SEPx - where x delimiter

/SEPPIPE - use '|' as delimiter
/SEPTAB - use Tab as delimiter

/SINGLEQUOTA - single quotas
/DOUBLEQUOTA - double quotas

/ALLQUOTAS - enclose all fields in quotas.

Dbase options

/DBASE3 - DBASE III format
/DBASE4 - DBASE IV format
/VFP - Visual Foxpro format

example:
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" c:\base\myfile.xls out.dbf /DBASE4

SQL options
/ORACLE - use Oracle syntax
/MYSQL - use MySQL syntax
/SQL2000 - use SQL2000 syntax
/POSTGRESQL - PostgreSQL syntax

Excel options

export to Excel 2003 (xml-based):
"c:\Program Files\Advanced XLS Converter\xlscnv.exe" file.xls outfile.xls /XML

HTML options

/ASFORM - one record on the one page

/NUMBER - record number as first column

/MAXPERPAGE - maximum records on the one page
example: /MAXPERPAGE=100

/TITLE - page title
example: /TITLE=Customers

/COLOR - Text color
example: /COLOR=#0000ff

/BACKGROUND - Background color
/BACKGROUND=#c0c0c0