1 <!-- Creator : groff version 1.18.1 -->
2 <!-- CreationDate: Fri Dec 9 14:11:52 2005 -->
5 <meta name="generator" content="groff -Thtml, see www.gnu.org">
6 <meta name="Content-Style" content="text/css">
11 <h1 align=center>xls2csv</h1>
12 <a href="#NAME">NAME</a><br>
13 <a href="#SYNOPSIS">SYNOPSIS</a><br>
14 <a href="#DESCRIPTION">DESCRIPTION</a><br>
15 <a href="#OPTIONS">OPTIONS</a><br>
16 <a href="#SEE ALSO">SEE ALSO</a><br>
17 <a href="#AUTHOR">AUTHOR</a><br>
23 <table width="100%" border=0 rules="none" frame="void"
24 cols="2" cellspacing="0" cellpadding="0">
25 <tr valign="top" align="left">
28 <p>xls2csv − reads MS-Excel file and puts its content
29 as comma-separated data on standard output</p>
32 <a name="SYNOPSIS"></a>
35 <table width="100%" border=0 rules="none" frame="void"
36 cols="2" cellspacing="0" cellpadding="0">
37 <tr valign="top" align="left">
40 <p><b>xls2csv</b> [<b>-xlV</b>] [<b>-f</b> <i>format</i> ]
41 [<b>-b</b> <i>string</i> ] [<b>-s</b> <i>charset</i> ]
42 [<b>-d</b> <i>charset</i> ] [-q <i>number</i> ] [<b>-c</b>
43 <i>char</i>] <i>files</i></p>
46 <a name="DESCRIPTION"></a>
49 <table width="100%" border=0 rules="none" frame="void"
50 cols="2" cellspacing="0" cellpadding="0">
51 <tr valign="top" align="left">
54 <p><b>xls2csv</b> reads MS-Excel spreadsheet and dumps its
55 content as comma-separated values to stdout. Numbers are
56 printed without delimiters, strings are enclosed in the
57 double quotes. Double-quotes inside string are doubled.</p>
60 <a name="OPTIONS"></a>
63 <table width="100%" border=0 rules="none" frame="void"
64 cols="4" cellspacing="0" cellpadding="0">
65 <tr valign="top" align="left">
74 <p>print unknown Unicode chars as \xNNNN, rather than as
77 <tr valign="top" align="left">
86 <p>list known charsets and exit successfully</p>
88 <tr valign="top" align="left">
92 <p><b>-c</b><i>char</i></p>
97 <p>cell separator char. By default - comma.</p>
101 <table width="100%" border=0 rules="none" frame="void"
102 cols="2" cellspacing="0" cellpadding="0">
103 <tr valign="top" align="left">
104 <td width="10%"></td>
106 <p><b>-b</b><i>string</i></p></td>
109 <table width="100%" border=0 rules="none" frame="void"
110 cols="2" cellspacing="0" cellpadding="0">
111 <tr valign="top" align="left">
112 <td width="23%"></td>
114 <p>sheet break string. This string (by default - formfeed)
115 would be output at the end of each workbook page. This
116 string is printed after page starting at start of line, but
117 no linefeed would be automatically added at the end of
118 string. Include newline at the ent of sheet separator if you
119 want it to appear on separate line by itself</p>
123 <table width="100%" border=0 rules="none" frame="void"
124 cols="4" cellspacing="0" cellpadding="0">
125 <tr valign="top" align="left">
126 <td width="11%"></td>
129 <p><b>-g</b><i>number</i></p>
134 <p>number of decimal digits in the numbers. By default
135 maximal double precision (system-dependent macro DBL_DIG) is
140 <table width="100%" border=0 rules="none" frame="void"
141 cols="2" cellspacing="0" cellpadding="0">
142 <tr valign="top" align="left">
143 <td width="10%"></td>
145 <p><b>-q</b><i>number</i></p></td>
148 <table width="100%" border=0 rules="none" frame="void"
149 cols="2" cellspacing="0" cellpadding="0">
150 <tr valign="top" align="left">
151 <td width="23%"></td>
153 <p>set quote mode. In quote mode 0 cell contents is never
154 quoted. In quote mode 1 only strings which contain spaces,
155 double quotes or commas are quoted. In quote mode 2
156 (default) all cells with type string are quoted. In quote
157 mode 3 all cells are quoted.</p>
161 <table width="100%" border=0 rules="none" frame="void"
162 cols="2" cellspacing="0" cellpadding="0">
163 <tr valign="top" align="left">
164 <td width="10%"></td>
166 <p><b>-d</b><i>charset‘</i></p></td>
169 <table width="100%" border=0 rules="none" frame="void"
170 cols="2" cellspacing="0" cellpadding="0">
171 <tr valign="top" align="left">
172 <td width="23%"></td>
174 <p>- specifies destination charset name. Charset file has
175 format described in CHARACTER SETS section of
176 <b>catdoc</b>(1) manual page. By default, current locale
177 charset would be used if langinfo support was enabled at the
182 <table width="100%" border=0 rules="none" frame="void"
183 cols="2" cellspacing="0" cellpadding="0">
184 <tr valign="top" align="left">
185 <td width="10%"></td>
187 <p><b>-s</b><i>charset</i></p></td>
190 <table width="100%" border=0 rules="none" frame="void"
191 cols="2" cellspacing="0" cellpadding="0">
192 <tr valign="top" align="left">
193 <td width="23%"></td>
195 <p>- specifies source charset. Typically, Excel files have
196 CODE PAGE record, which denotes input charset, but for some
197 reason you may wish to override it.</p>
201 <table width="100%" border=0 rules="none" frame="void"
202 cols="2" cellspacing="0" cellpadding="0">
203 <tr valign="top" align="left">
204 <td width="10%"></td>
206 <p><b>-f</b><i>format</i></p></td>
209 <table width="100%" border=0 rules="none" frame="void"
210 cols="2" cellspacing="0" cellpadding="0">
211 <tr valign="top" align="left">
212 <td width="23%"></td>
214 <p>- specifies date/time format to use for output of all
215 Excel date and time values. If this option is not specified,
216 format, specified in the spreadsheet is used. On POSIX
217 system any format, allowed by <b>strftime</b>(3) can be used
218 as value of this option. Under MS-DOS <b>xls2csv</b>
219 implements limited set of <b>strftime</b> formats, namely
220 <b>m</b>, <b>d</b>, <b>y</b>, <b>Y</b>, <b>b</b>, <b>l</b>,
221 <b>p</b>, <b>H</b>, <b>M</b>, <b>S</b>.</p>
225 <table width="100%" border=0 rules="none" frame="void"
226 cols="5" cellspacing="0" cellpadding="0">
227 <tr valign="top" align="left">
228 <td width="11%"></td>
233 <td width="14%"></td>
236 <p>outputs version number</p>
241 <a name="SEE ALSO"></a>
244 <table width="100%" border=0 rules="none" frame="void"
245 cols="2" cellspacing="0" cellpadding="0">
246 <tr valign="top" align="left">
247 <td width="10%"></td>
249 <p><b>cat</b>(1), <b>catdoc</b>(1), <b>strings</b>(1),
250 <b>utf</b>(4), <b>unicode</b>(4)</p>
253 <a name="AUTHOR"></a>
256 <table width="100%" border=0 rules="none" frame="void"
257 cols="2" cellspacing="0" cellpadding="0">
258 <tr valign="top" align="left">
259 <td width="10%"></td>
261 <p>V.B.Wagner <vitus@wagner.pp.ru>, based on biffview