1xls2csv(1)                  General Commands Manual                 xls2csv(1)
2
3
4

NAME

6       xls2csv  -  reads MS-Excel file and puts its content as comma-separated
7       data on standard output
8

SYNOPSIS

10       xls2csv [-xlV] [-f  format ] [-b  string ] [-s  charset ] [-d   charset
11       ] [-q  number ] [-c  char] files
12
13

DESCRIPTION

15       xls2csv reads MS-Excel spreadsheet and dumps its content as comma-sepa‐
16       rated values to stdout. Numbers are printed without delimiters, strings
17       are enclosed in the double quotes. Double-quotes inside string are dou‐
18       bled.
19

OPTIONS

21       -x      print unknown Unicode chars as \xNNNN, rather than as  question
22               marks
23
24       -l      list known charsets and exit successfully
25
26       -cchar  cell separator char. By default - comma.
27
28       -bstring
29               sheet  break  string. This string (by default - formfeed) would
30               be output at the end of each  workbook  page.  This  string  is
31               printed  after  page starting at start of line, but no linefeed
32               would be automatically added at the end of string. Include new‐
33               line  at the ent of sheet separator if you want it to appear on
34               separate line by itself
35
36       -gnumber number of decimal digits in the numbers.  By  default  maximal
37                double precision (system-dependent macro DBL_DIG) is used.
38
39       -qnumber
40               set  quote mode. In quote mode 0 cell contents is never quoted.
41               In quote mode 1  only  strings  which  contain  spaces,  double
42               quotes  or  commas  are  quoted.  In quote mode 2 (default) all
43               cells with type string are quoted.  In quote mode 3  all  cells
44               are quoted.
45
46
47       -dcharset`
48               -  specifies  destination charset name. Charset file has format
49               described in CHARACTER SETS section of catdoc(1)  manual  page.
50               By  default,  current  locale charset would be used if langinfo
51               support was enabled at the compile time.
52
53
54       -scharset
55               - specifies source charset. Typically, Excel  files  have  CODE
56               PAGE  record,  which denotes input charset, but for some reason
57               you may wish to override it.
58
59       -fformat
60               - specifies date/time format to use for  output  of  all  Excel
61               date  and  time  values.  If this option is not specified, for‐
62               mat, specified in the spreadsheet is used. On POSIX system  any
63               format,  allowed  by  strftime(3)  can be used as value of this
64               option. Under MS-DOS xls2csv implements limited set of strftime
65               formats, namely m, d, y, Y, b, l, p, H, M, S.
66
67
68       -V      outputs version number
69
70

FILES

72       ${HOME}/.catdocrc, catdoc charset files and substitution map files (see
73       catdoc(1) manual page for details,
74
75

SEE ALSO

77       cat(1), catdoc(1), strings(1), utf(4), unicode(4)
78
79

AUTHOR

81       V.B.Wagner <vitus@45.free.net>, based on biffview by David Rysdam
82
83
84
85MS-Word reader                  Version 0.94.2                      xls2csv(1)
Impressum