Bernd Schmitt said:
I am looking for a command line tool to convert xls-files to csv/txt files.
Open source would be perfect ...
Now, I found that catdoc includes xls2csv which is exactly what I need.
http://www.45.free.net/~vitus/ice/catdoc/ver-0.9.html
NAME xls2csv
reads MS-Excel file and puts its content as
comma-separated data on standard output
SYNOPSIS xls2csv [-xlV] [-s charset ] [-d charset ] [-q number ] [-c char]
files DESCRIPTION xls2csv reads MS-Excel spreadsheet and dumps
its content as comma-separated values to stdout. Numbers are
printed without delimiters, strings are enclosed in the double
quotes. Double-quotes inside string are doubled.
OPTIONS -x
print unknown unicode chars as xNNNN, rather than as question
marks -l list known charsets and exit successfully
-cchar
cell Separator char. By default - comma.
-qnumber
set quote mode. In quote mode 0 cell contents is never quoted.
In quote mode 1 only strings which contain spaces, double
quotes or commas are quoted. In quote mode 2 (default) all
cells with type string are quoted. In quote mode 3 all cells
are quoted.
-dcharset
specifies destination charset name. Charset file
has format described in CHARACTER SETS below and should
have. By default, current locale charset would be used if
langinfo support was enabled at the compile time. .txt
extension and reside in catdoc library directory
(${exec_prefix}/lib/catdoc).
-dcharset
specifies destination charset name. Charset file has format
described in CHARACTER SETS section of catdoc(1) manual
-scharset
specifies source charset. Typically, Excel files have CODE
PAGE record, which denotes input charset, but for some reason
you may wish to override it.
-V
outputs version number
BUGS
Date cells are not recognized and printed as floating point
number of days since 1-01-1900. Probably many others.
SEE ALSO
cat(1), catdoc(1), strings(1), utf(4), unicode(4)
AUTHOR
V.B.Wagner <
[email protected]>, based on biffview by David Rysdam
Ciao,
Bernd
